I installed MySQL and trying to get it working for few days, it wasn't easy. I am so massed up now it's not even funny, here is what I did.
[[email protected] mysql]# mysqladmin -u root --password=<pass>
it just gave me the mysqladmin help page
[[email protected] mysql]# mysql -u root
ERROR 1045: Access denied for user: '[email protected]' (Using password: NO)
[[email protected] mysql]# mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47 to server version: 4.0.17-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE HELLO_WORLD;
ERROR 1044: Access denied for user: '@localhost' to database 'HELLO_WORLD'
mysql>
I use mysql with PHP, it was so easy, but when comes to command line, I don't know how it works.. From the above errors, can anyone tell me where I went wrong?
[[email protected] mysql]# mysqladmin -u root --password=<pass>
it just gave me the mysqladmin help page
[[email protected] mysql]# mysql -u root
ERROR 1045: Access denied for user: '[email protected]' (Using password: NO)
[[email protected] mysql]# mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47 to server version: 4.0.17-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE HELLO_WORLD;
ERROR 1044: Access denied for user: '@localhost' to database 'HELLO_WORLD'
mysql>
I use mysql with PHP, it was so easy, but when comes to command line, I don't know how it works.. From the above errors, can anyone tell me where I went wrong?
Comment