Mysql database creation doubt

[jasoothai]

When creating mysql database user, I think following command is used :

CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123';

What I have to put the highlighted part, "localhost" or my vps ip address ?
Thank you for the help...

jasoothai Reviewed by jasoothai on 8th Jul 2012. Mysql database creation doubt When creating mysql database user, I think following command is used : CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123'; What I have to put the highlighted part, "localhost" or my vps ip address ? Thank you for the help... Rating: 5

[mRAza]

localhost will work if you have not changed it, and here is a complete command to add user with privileges on some database.

GRANT ALL PRIVILEGES 
       ON DATABASENAME.* 
       TO 'YOURUSER'@'localhost'
       IDENTIFIED BY 'YOURPASSWORD' 
       WITH GRANT OPTION; 

// DATABASE = your database name
//YOURUSER = your username for mysql
// YOURPASSWORD = your password for mysql user

More info here

[jasoothai]

That page says :

if you're going to access this database from another computer system, you'll need to specify the IP address of that remote system here instead of "localhost".

What is the ip address of remote system, Is it the IP address of VPS ?

[mRAza]

if you are going to use mysql from another server/IP then you need to provide your location IP where script is hosted but if script is hosted on same server where mysql database is then you will only use localhost.

[jasoothai]

Thanks, That's clarified...