[plug] mysql installation

[Dave Dartnall]

I note a recent request for assistance from Jim Householder re a mysql 
installation in Mandrake 10. I'm having exactly the same problems...

The mysql installation went well, mysql_install_db was run as root (as 
suggested by Leon Kyneur), I can 'USE test' and create tables in this 
database, populate and retrieve data from them etc but...
	mysql> SHOW DATABASES;  returns 'test' only, no reference to mysql or tmp.
	mysql> CREATE DATABASE records; returns:
		ERROR 1044: Access denied for user : '@localhost' to database 'records
	$ mysqladmin -u root password 'rootpassword' returns
		mysqladmin: connect to server at 'localhost' failed
		Error: access denied for user 'root at localhost' (Using Password: NO)
		(this also was run as root with similar results)
	Reference is made in the documentation of 'syntax.txt' which I don't have.
I just can't see how to get administrator privileges at server level...

As a matter of interest, I had to create a file /var/lib/mysql/mysql.sock 
(touch /var/lib/mysql/mysql.sock) and I was surprised that the system 
accepted this without further linkage. How does this work?

In addition, reference to the gnome system monitor while running the client 
process 'mysql' and referencing the trial table set under the 'test' database 
which is the only thing I can do - (can't create a new database) I notice 
that while "mysql' is shown to be running the server 'mysqld' is not shown as 
a process which is running or sleeping.I was assuming that it would not be 
possible to work with the 'test' db without the server running. Am I wrong?
	mysql> \s   seems to indicate that the server is in fact running!

Did you have any success  Jim, and if so could you or any other Plugger give 
me a lead on where to go from here please.

regards
Dave Dartnall