Permission problem (Linux + MySSQL)

[weronpc]

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?

[raf]

check here http://www.mysql.com/articles/ddws/4.html fot the installation and pre-installation tasks

[weronpc]

raf, thank you for your reply.

PHP and MySQL is easy. I just don't know how to use mysql on Linux Command line.

I don't know how to set up permission and stuff, I also don't understand www.mysql.com's documentation.

I am new to this, If you had installed mysql on linux and use command line query, please help me

thank you

[raf]

Originally posted by weronpc
I just don't know how to use mysql on Linux Command line.
I don't know how to set up permission and stuff, I also don't understand www.mysql.com's documentation.

The link i posted contains some general commandline syntax.

I don't know what sort of help you want. You just need to read up on that article and on some of the other that are available at mysql.com

The mysql.com manual is also quite good so i don't quite see what you don't understand about it.