MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2)
 

Hi,

I have been unable to install MySQL 5.0.67 correctly. MySQL 5.1.31 also problematic.

Successfully ran 'mysql_install_db'.


You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

cd /usr ; /usr/bin/mysqld_safe &
[1] 21074
linux-qj5v:/usr # nohup: ignoring input and redirecting stderr to stdout
Starting mysqld-max daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/linux-qj5v.site.pid
090304 17:23:31 mysqld ended


I have tried running command: /usr/bin/mysql_secure_installation from Terminal in Root, and just 'mysql' in root.

'ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

I've tried installing via a .tar.gz file instead. This doesn't generate the icons in the menu for Admin, db design & query tools, and also won't run.

I can find references to this problem in various Google entries, but not a solution that fixes the issue. Anyone have any advice?

Thanks,
Petey

Did you run mysql_install_db with the --user=mysql option? If you didn't, that's going to be a problem.

Also, look to see what's in /var/lib/mysql; the owner and group are mysql, set by mysql_install_db --user=mysql.

I stumbled on an article on Apache:
http://en.opensuse.org/Linux_Apache_...P_Server_(lamp)

This showed a way to get into Software > Software Mgmt in YAST Control, and then enable MySQL. Once done, Terminal could reach MySQL completely and I setup a secure install, removing test db and anon users.

I now have the SQL prompt and will play around and see if seems to functioning correctly. A Show databases; command listed:

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
+--------------------+
2 rows in set (0.00 sec)

That looked right.

Petey