Ashok Kumar wrote: > Hi Peter, > If i give the localhost/IP addr, How can i set the > security previleges in my server/system( i have > installed apache server to run the scripts). as i told > earlier i'm using win2000 os, its expecting lot of > securitie prevleges. i can't find those settings. if u > know abt apache server means pls tell something abt > that.
It is not the apache server that accesses the mysql server, but the scripting engine of your choice. > I tried to access my system's mysql db and as well as > the scripts in the apache server from other system, > it's asking for the username and password. I didn't > give any username and pwd to my system(i disabled sys > pwd) and also to db. Why it's asking for the username > and pwd. i tried all the username and pwd > combinations. but no result. > If u have any idea pls share with me. When connecting to the mysql server in your script, you must use three parameters: 1. Host name / ip address 2. Username 3. Password I am not familiar with the scripting engine of your choice, but the command to set up a connection to a mysql server would be something like: // Establish connection myConnection = mysql_connect (myHostName, myUserName, myPassword); // Select database on server using connection myDatabase = mysql_select_db( myDatabaseName, myConnection); Check the documentation for the scripting engine for the right syntax and commands. The username is the name of a mysql user etc. Now, consider you have created a database called 'myDatabaseName' you have to set up the user (myUserName) to allow access to this database: 1. Enter the mysql command line client mysql> GRANT ALL PRIVILEGES ON myDatabaseName.* TO 'myUserName'@'HostNameOrIPAddressOfApacheServer' IDENTIFIED BY 'myPassword'; 2. Flush the mysql server user privilege cache mysql> FLUSH PRIVILEGES; Now go read the manual. Peter Normann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
