php & mysql.

[GOMEEE]

ok i dont it through phpmyadmin, and pasted those lines in.

just so i know what i have just done lol....

create database php default character set utf8; <-- created the database?
grant all on php.* to 'php'@'localhost' identified by 'php' with grant option; <-- set up a user on localhost for the php database only? and that last php is the password?
grant all on php.* to 'php'@'localhost.localdomain' identified by 'php' with grant option;

if im wrong please explain wht set what lol. but its worked

ty kaori and farphit for your attempts

 

[Kaori]

that's right... line 2 and 3 means you are giving the user php@localhost or [email protected]ldomain access with the password php.

 

[GOMEEE]

ty kaori u are a legend

how would i write it out and set them certain permissions? like so they can only view and edit a table, but not create one.

 

[Kaori]

instead of grant all

grant select,insert,update on php.* to 'php'@'localhost' identified by 'php';
flush privileges;

 

[GOMEEE]

thnx again kaori. ur a star

 

[Kaori]

no problems