MySQL

X11 · 08-19-2002, 02:05 AM

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:

Code:

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:

Code:

./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.

Code:

./configure --prefix=/usr/local/mysql

NOTE: I Followed the stuff below from a file called INSTALL-BINARY under the directory called
Docs from where the source package was extracted to.

Code:

     
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> scripts/mysql_install_db
     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 &

j-ray · 08-19-2002, 05:51 AM

i don´t know whether or not the mysqld is already started.
if not i would cd into the mysql directory and run
./bin/safe_mysqld start or
./bin/safe_mysqld mysql&
or sth like that (i don´t know exactly)
if it´s running you can log in
'mysql -u mysql -p;'
this should open a dialog where u fill in your password->
then u can
mysql%: create database yourdb;
mysql%: use yourdb;
create table...

or
log in as root
mysql -u root -p
and create users dbs and tables within mysql
p.s.: i doubt it´s a good idea to call the user 'mysql'. think about that.
so if i´m wrong post the error message u receive.
cheers, jens