WTF mysql.. run damn you!

scrupul0us · 01-08-2006, 10:29 AM

So whats the deal with mysql as installed with slack 10.2? everytime i try to run the mysql command i get the follow error:

"Cant connect to the local mysql server through socket '/var/run/mysql/mysql.sock' (2)"

scratches head...

also, where are the DB files stored? in a windows env they were stored in mysql/bin/

neither myself nor slocate can find that path

HELP

phil.d.g · 01-08-2006, 11:03 AM

mysql is the client program.

Can you briefly outline the steps you have already done in getting mysql setup

The error you specified means that either the mysql daemon isn't running, or the client is expecting the socket file to be in a different location that where mysqld is putting it.

Normally mysql data files are stored somewhere under /var. I *think* its /var/lib/mysql - I always move it elsewhere where there is more space and where I can more easily back up the data

scrupul0us · 01-08-2006, 11:17 AM

i havent tocuhed mysql at all... i did a full install of slack 10.2 so i just assumed it would be setup and running (since apache was) and all id have todo was config it

i tried googling for a setup for 10.2 but found nothin

phil.d.g · 01-08-2006, 11:24 AM

Ok,

if you do:

Code:

$ su -
# su - mysql
$ mysql_install_db
$ exit
# chmod 755 /etc/rc.d/rc.mysqld
# /etc/rc.d/rc.mysqld start
# exit

note that you must run mysql_install_db as user mysql which is done by `su - mysql`

That should do it, reading /etc/rc.d/rc/mysqld /var/lib/mysql is indeed the default location for mysql databases.

Remember the mysql root password will be blank at this point.

Alien_Hominid · 01-08-2006, 01:55 PM

Mysql is not fully configured in default Slackware installation. You must configure it yourself as phil.d.g told. As well, read this /etc/rc.d/rc.mysqld.

scrupul0us · 01-08-2006, 02:06 PM

phil that worked nicely... i also changed the pw for root using

Code:

#mysqladmin -u root password "newpassword"

only issue now is that phpmyadmin reports:

Code:

#2013 - Lost connection to MySQL server during query

when i try to login using root and the new password

im using the same phpmyadmin setup as before and dont see anything inside config.inc.php should change, but i looked that over just to be sure

also.. what and where do i edit so that mysql starts at boot

shilo · 01-08-2006, 02:28 PM

Code:

less /etc/rc.d/rc.mysqld # All the info you need
sh /etc/rc.d/rc.mysqld start # Start mysql
chmod +x /etc/rc.d/rc.mysqld # Make mysql start at boot

phil.d.g · 01-08-2006, 04:12 PM

By chmodding the rc script to 755 you made it so that mysqld starts on boot up.

I think the problem may be because mysqld isn't listening on a tcp port, in phpmyadmin's config.inc.php change the connection type to socket and the socket location to /var/run/mysql/mysql.sock

---
FOR MYSQLD: Now you have got it running you may want to read the my-*.cnf in /etc files and write a my.cnf to optimise mysql a bit for your circumstances and set your own options, as well as reading /etc/rc.d/rc.mysqld

scrupul0us · 01-08-2006, 07:35 PM

ok.. i did the chmod and changed the type to SOCK and entered the SOCK path and i still get the same error

shilo · 01-08-2006, 07:52 PM

use "ps aux" to verify mysql is running. Manually verify that the databases all have the correct ownership.

scrupul0us · 01-08-2006, 08:48 PM

mysql is running ownership is mysql mysql

phil.d.g · 01-09-2006, 07:47 AM

Can you connect with the mysql client

Code:

mysql -u root -p

after supplying your password you should be greeted with some information about the mysql server and the mysql prompt:

Code:

mysql>

gbonvehi · 01-09-2006, 11:25 AM

You may need to comment SKIP="--skip-networking" in /etc/rc.d/rc.mysqld if your program connects using a tcp port.
Also there are some sample configuration files in /etc, all of them end with .cnf. Copy the one you need as /etc/my.cnf

scrupul0us · 01-09-2006, 04:13 PM

i got it to work... in the config.inc.php:

Code:

$cfg['Servers'][$i]['host']

was set to:

Code:

'http://www.myhost.com';

the only way itll work now is if i set it to:

Code:

'localhost';

strange but oh well it works

phil.d.g · 01-09-2006, 04:24 PM

Its probably because mysql isn't listening on a tcp port, only through that socket file. Unless you have remote clients connecting to mysql then there is no need to change this