LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware > Slackware - Installation
User Name
Password
Slackware - Installation This forum is for the discussion of installation issues with Slackware.

Notices


Reply
  Search this Thread
Old 03-03-2004, 03:33 AM   #1
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
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.
 
Old 03-03-2004, 10:28 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
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.
 
Old 03-03-2004, 11:10 AM   #3
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Original Poster
Rep: Reputation: 30
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.


Last edited by buttersoft; 03-03-2004 at 04:21 PM.
 
Old 04-02-2004, 09:36 PM   #4
dizzy_vee
LQ Newbie
 
Registered: Mar 2004
Distribution: SuSE 9, Mandrake 10
Posts: 19

Rep: Reputation: 0
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.
 
Old 04-12-2004, 09:56 PM   #5
M.Bertalan
LQ Newbie
 
Registered: Apr 2004
Posts: 1

Rep: Reputation: 0
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
 
Old 03-15-2005, 04:39 PM   #6
naveenkoneru
LQ Newbie
 
Registered: May 2004
Posts: 3

Rep: Reputation: 0
Thumbs up

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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL startup error goosie Linux - Software 13 11-16-2005 03:30 PM
mysql startup eyewittness Linux - Software 1 07-23-2005 09:04 AM
stopping mysql during startup snutz411 Linux - General 2 02-28-2005 10:53 AM
Getting MySql to run on startup jriis Debian 8 03-16-2004 12:20 PM
I want MySQL to run at startup WorldBuilder Linux - General 12 06-14-2003 01:45 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware > Slackware - Installation

All times are GMT -5. The time now is 11:53 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration