[MLUG] MySQL

[Mike Pepper <EMAIL:PROTECTED>]

I am attempting to install MySQL version 4.021-4i586.
Everything installs and runs fine,
As you can see below, I am unable to start MySQL as root, yet I can
start it as a normal user.
-----------------------------------------------------------------------
procurement:/home/mike # mysql
ERROR 1045: Access denied for user: EMAIL:PROTECTED (Using password:
NO)
procurement:/home/mike # exit
exit
EMAIL:PROTECTED:~> mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31 to server version: 4.0.21
                                                                           
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
                                                                           
mysql>
------------------------------------------------------------------------
I can live with this.

my problem is setting permissions.
This is a stock install. I have both the server and the client modules
installed.
All of the documentation that I have looked at tells me that the first
thing that I need to do is run as root: mysqladmin -u root -h localhost
password blah
here is what happens when I attempt to run it:
------------------------------------------------------------------------
procurement:/home/mike # mysqladmin -u root -h localhost password blah
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: EMAIL:PROTECTED (Using password: NO)'
procurement:/home/mike #
------------------------------------------------------------------------
It does not matter if I bump down to a normal user or not. I just can't
see to get past this.
I have opened open port 3306 for both TCP and UDP.
I am working on a SuSE 9.2 box.


any help would be appreciated.

Thanks

Mike

_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members