Hi,
I've setup MySQL, but whenever I try to run

bin/mysqld_safe --user=mysql &

as instructed in the docs I get the error:-

Cannot connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

I've tried editing the mysql.sock file with pico but it's empty.

I'm on SlackWare 9

PLEASE HELP

try removing it, then connect again. that's the only thing I can think of right now

I can't get MySQL to load anymore, I keep getting this error:-

root@linuxy:/usr/local/mysql# mysqld --user=root mysql
030901 0:06:58 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
030901 0:06:58 InnoDB: Flushing modified pages from the buffer pool...
030901 0:06:58 InnoDB: Started
030901 0:06:58 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist


Also does anyone know how to have MySQL load on boot with SlackWare?

If I do

safe_mysqld --user=root

It loads, I've created a database called testdb but I cannot access it, I'm getting

Access denied for user: 'mysql@localhost' (Using password: YES)

How do I setup a username and password for the database? I'm completely lost, please help.

Is running MySQL in this way the problem?

To start the mysql server, try running ./safe_mysqld from the bin directory without additional parameters. If you specify the user=mysql, make sure the mysql user exists in /etc/passwd

To set up the admin user password, make sure you have the admin tools installed and run:

mysqladmin -u root password 'new password'

also make sure to run the following after setting the root password:

mysqladmin flush-privileges

First, make sure that you've set up the database according to the mySQL instructions . From the second post that cosmicperl put up, it looks like that could be the problem. One of the things this procedure does is to set up the mysql table. NOTHING works without that.

Second, make sure the files in /var/lib/mysql are owned by mysql and not root. If they are owned by root, chown them so they are owned my mysql. Also check what is in /tmp. On my system, /var/mysql.sock is a link to /var/run/mysql/mysql.sock. Do a whereis mysql and see if you can locate mysql.sock.

Third, check some of the solutions from the MySQL site .

Finally, did you set a root password? The line you give (safe_mysqld --user=root) doesn't ask for one. If you DID set a root password, you need to use safe_mysqld --user=root -p, in which case it is going to be tough to start mysql at boot time. You can reset root's
password .