Results 1 to 2 of 2
Thread: user name and password
May 19, 2002, 18:01 #1
- Join Date
- Apr 2002
- 0 Post(s)
- 0 Thread(s)
user name and password
Hi how are you doing ? I am doing my sql but I don't know how to make user name and password into my sql.
actually I did like this:
mysql -u itohideo -p<japan.sql
Pleae tell me the codes for username and password.
May 19, 2002, 23:46 #2
Have you created a username "itohideo"?
If not, then you must log in as root and create a username first. To log in as root just type "mysql" and press enter. Then create a username using this statement:
GRANT ALL PRIVELEGES ON *.* TO itohideo@localhost IDENTIFIED BY yourpassword;
On successful execution of the above statement you can log in to MySQL using the statement:
> mysql -h localhost -u itohideo -p
Hope this helps.