I guess I want to start from the beginning.


I take it that in this command:

mysqladmin -u root password yourrootsqlpassword

root: Is not the linux root super user correct?
yourrootsqlpassword: Is anything you want to make up?

My question is how do you test that account?
It seems all I have to do is type $mysql
and I get the prompt. How do I secure this:

Your MySQL connection id is 24 to server version: 4.0.21-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

How can I make sure that root and it's password work is what I'm trying to say. Is there a command or test I can run....

Sorry really new and willing to break mysql just so I can learn a thing or two?

root in Mysql refers to the administrative user of the DBA. ie the DB administrator. It's not the same thing as Linux root (the overall system administrator).

Every mysql db has a set of system tables (db,columns_priv, tables_priv etc) associated with security. SQL commands like GRANT and REVOKE will alter these tables, athough you can directly manipulate them via UPDATE/INSERT/DELETE. Look up the official MySQL docs for more info.

I guess you started at switching user to root.

su root (type password)

If you didn't download it, then it's in one of your disto's CD, like mine. In which case, you just type "urpmi mysql". Then follow instructions. Surf to directory /etc/rc.d/init.d/ and type "mysql restart". Then type "mysqladmin -u root password 'whateverpassword'". This is as far as i got, cause when i try the next steps, the password i typed doesn't work.

mysql -u root -p
mysql> create database mydb;
mysql> grant select, insert, delete, update, create, drop, index
on mydb.* to
myuser identified by 'hello';
mysql> flush privileges;
mysql> \q

Here's the link so you get more info about this.

http://vsbabu.org/mt/archives/2003/0...ndrake_91.html