[plug] mysql installation

[Dave Dartnall]

On Sat, 10 Jul 2004 01:31 pm, Jim Householder wrote:
> Dave Dartnall wrote:
> > 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...

> I managed to get mine working by starting over from scratch.  I had dug my
> hole too deep.  The key was (a last resort!) studying the documentation
> (sigh). /usr/share/doc/MySQL-4.0.18/manual.html
> After installing the RPMs, section 2.4.2 contains unix post-installation
> procedures.  If you are installing from RPMs, do not try to execute
> mysql_install_db.  It has already been done.
> 'mysql -u root password' tries to open a database named 'password' which
> does not exist.
> If you are not user 'root' or 'mysql', you will not see the mysql database,
> only test.
> Initially no passwords are set.
> > mysql -u root mysql
> should give you access to the 'mysql' database which stores the usernamess
> & privileges
> > mysql -u root -p mysql
> does the same, but asks for a password before proceeding.
> Jim
Thanks Jim and William Kenworthy...
I've removed and reinstalled twice, and get the feeling that the MDK has done 
their installation with a root password. I have indeed rtfm with little 
success - any effort to execute mysql -u root mysql or similar have all 
resulted in denial of access, contrary to what's described in the docs. I'm 
stumped. - but still trying. Very.
It's not easy reading those docs - there are over 700 pages of 'em.
Dave D