Mysql install and startup
 

Hi I am OK with MySQL on SuSE for about 10 months, but now I wish to switch to Slack and everything is working except for MySQL!

I chose to install MySQL on initial installation, but I am just getting nowhere as to starting the server and copying over my databases.

Can someone give me here a link or exact instructions in Slack 9.1 to get MySQL up and running? That would be cool.

I thought I messed up before so I used pkgtool to remove MySQL, then I rebooted and used the pkgtool again.

First of all I have the cannot find mysql.sock problem to overcome.
Then I need to start the server.

All of this stuff I could do without a hitch in SuSE distribution!

So I am a real newbie again!

Please help.

After installing mysql with pkgtool do the following (which I should mention this has come up far too many times with answers, a search would have found this most likely):

# mysqld_install_db
# chown -R mysql.mysql /var/lib/mysql
# mysqld_safe &

That should start it manually and you can edit your rc.d scripts, rc.M in particular to start mysql at startup. If your using Slackware 9.1 it should already have the rc.mysqld script in that directory. Might just need to make it executable:

chmod +x /etc/rc.d/rc.mysqld

Cheers.

Done all that but now I have this

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

Just found a note I made once:-

ln -s /var/lib/mysql/mysql.sock /tmp

If memory serves well, this is how to create this darn sock.

Then hopefully I am on my way....

YES YES

ln -s /var/lib/mysql/mysql.sock /tmp

MySQL now running.

Trickykid,

Well, not sure what was wrong with mysql on my suse 9... i tried everything to get it running including the tutorials. Then I followed your little instructions here and it works! Thanks.

Dizzy V.

Help !!! Please someone help me !!

Im totaly newbies in linux and MySQL.

I had install a linux Red Hat some time ago, and toghter i installed MySQL. I never used MySQL before, but now i would like to try.

So i made a download of MySQL-client-4.0.18-0.i386.rpm because is more easy to install, but when i do this i receive a error mensage:

warning: MySQL-client-4.0.18-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
package MySQL-client-4.0.18-0 is already installed
file /usr/bin/mysql from install of MySQL-client-4.0.18-0 conflicts with file from package mysql-3.23.52-3
file /usr/bin/mysqlaccess from install of MySQL-client-4.0.18-0 conflicts with file from package mysql-3.23.52-3
file /usr/bin/mysqlbinlog from install of MySQL-client-4.0.18-0 conflicts with file from package mysql-3.23.52-3

So i was reading and i need to import the pubkey, but when i do this i receive this menssage:
rpm --import mysql_pubkey.asc

[root@server]# rpm --import mysql_pubkey.asc
error: mysql_pubkey.asc: import read failed.

And i try to locate the file mysql_pubkey.asc, and i dont found nothing. I dont know more what to do.

I tried to re-install using binary and rpm version, i tried to erase and re-install, and this never works.

The normal steps:
bash-2.05b$ /usr/local/mysql-4.0.18/scripts/mysql_install_db
Installing all prepared tables
040413 0:00:48 /usr/local/libexec/mysqld: Shutdown Complete
# Looks likes works.

bash-2.05b$ ../bin/mysqld_safe &
[1] 8724
bash-2.05b$ Starting mysqld daemon with databases from /var/lib/mysql
040413 00:02:47 mysqld ended

bash-2.05b$ mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Please, I dont konw more what i can do. Someone have a idea ???

Thank You Very Much

M.Bertalan,
Make sure that your public Key file begins with
"Key ID:"
Sometimes... accidentally it begins with "D:".. that is the "Key I" gets truncated.
This is all that I can tell... I am newbie myself.
Thanks,
Naveen