Newbie help needed with mysql

[john]

When I start safe_mysqld &, I get a command prompt back again and ps aux
shows this:

mysql 30269 0.0 0.1 10580 1024 pts/1 S 17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid
mysql 30271 0.0 0.1 10580 1024 pts/1 S 17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid
mysql 30272 0.0 0.1 10580 1024 pts/1 S 17:38 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/rock.pid

Next I tried this:

mysqladmin create testDB and I got this error:

root@rock:/archives# mysqladmin create testDB

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!

I havent found any info on this online as I did a search for:

Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)

Both at the list archive at mysql.com and with google. I bet I could refine my search, but I dont know where to start.

Please help.

Thanks.

John

[EMAIL PROTECTED]


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php