mysql user
 

hi people ..

how to create mysql root user to setup phpmyadmin ..

i'm tried to use this command

mysql --user=root --password=mypassword

it said

Error 1045 : Access denied for user: 'root@localhost' (Using password: YES)

how can i create user to setup phpmyadmin ..

i'm using Fedora core 1

thanx

well i had something similar happen. when i first set up my sql i had nothing but root ((when logged in under root)) could create or do anything with tables. their is a default access table when setting up. that only root can do anything with sql. i don't remember what the table is :( but i found it on one of the many "how to" pages. one such how to is about PHP how to .. .i skimmed it and it might help .. but if you are having access usage issues you will need to go to the systems table((don't know the name)) and alter it

sorry i could not help any more than that

mysqladmin --user=root password mypassword

should set a password for root, assuming mysqladmin is in your path.

If this is a clean mysql install you should be able to log into it just doing

mysql

or

mysql -u root

If it is don't forget to delete the "blank user"

... before setting a password for root

if you did set a password for root using e.g. the command suggested by Looking_Lost you need 'mysql -p' or 'mysql -u root -p' to login (this will prompt for the password). when logged in as root you can set up permissions for any other user using mysql's 'grant' command (see the documentation for details)