I'm trying to get MySQL setup properly for mainly purpose of learning how-to use it.
But I seem to have a problem that I can't figure out; Every time on I type in the following:
mysqladmin -u mysql -p CREATE shop
and in the password for that user (Which I think I have done right???), it spits out the following message:
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql@localhost' (Using password: YES)'
BTW: Here's a bit about my setup:
- I have compile MySQL version 3.23.51 from source on Slackware Linux 8.1.
- The options I have used for the configure
script just include the path of the root
directory for the MySQL installation. eg.
NOTE: I Followed the stuff below from a file called INSTALL-BINARY
under the directory called
from where the source package was extracted to.
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R root /usr/local/mysql
shell> chown -R mysql /usr/local/mysql/data
shell> chgrp -R mysql /usr/local/mysql
shell> chown -R root /usr/local/mysql/bin
shell> bin/safe_mysqld --user=mysql &