LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 10-08-2004, 02:24 PM   #1
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Rep: Reputation: 15
problem starting mysql, new install


Hello everybody,

just installed mysql and the installation seem to go ok..
according to research it looks like a permission err msg but i'm not sure how to correct the problem.

do i give permission to the tmp folder or do i modify the my.cnf file to correct this issue

one of the research i ran inot said to created a folder /var/mysqldata/ to fix this problem but how do i tell it to store the mysql.sock into tis folder..
i also gave group and user mysql rights to this folder.
or am i on the wrong path to resolving this issue?

any help u can give me would be greatly appreciated.


and this is the error i received:
[root@comgen mysql]# bin/mysqld_safe --user=mysql &
[1] 29804
[root@comgen mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/comgen.ca.pid
041007 21:41:03 mysqld ended
[1]+ Done bin/mysqld_safe --user=mysql

log file
mysql started
warning: asked for 196608 thread stack, but got 126976
usr/local/mysql/bin/mysql: can't read dir of '/root/tmp/' errcode 13
usr/local/mysql/bin/mysql: can't create/write to file '/root/tmp/ibwnkdan
/usr/local/mysql/bin/mysql: shutdown complete
mysql ended
 
Old 10-08-2004, 04:37 PM   #2
nightoil
LQ Newbie
 
Registered: Oct 2003
Location: Thailand
Distribution: Slackware 10.0
Posts: 29

Rep: Reputation: 15
Hi, I'm no mysql expert, but I found that you need to change the ownership of the directories mysql created when you issued the command 'mysql_install_db' from root:root to mysql:mysql. Try (as root)

chown -R mysql:mysql /usr/local/mysql
 
Old 10-08-2004, 05:54 PM   #3
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Original Poster
Rep: Reputation: 15
still getting the same problems...i'm lost on this one..
where can i go to have this point to a different folder..
mysql started
warning: asked for 196608 thread stack, but got 126976
usr/local/mysql/bin/mysql: can't read dir of '/root/tmp/' errcode 13
usr/local/mysql/bin/mysql: can't create/write to file '/root/tmp/ibwnkdan
/usr/local/mysql/bin/mysql: shutdown complete
mysql ended
 
Old 10-08-2004, 06:17 PM   #4
nightoil
LQ Newbie
 
Registered: Oct 2003
Location: Thailand
Distribution: Slackware 10.0
Posts: 29

Rep: Reputation: 15
...mmmm looks like mysql is trying to write to /root/tmp. Instead of just /tmp

I've had a look at /etc/my.cnf on my machine and I see a line that's commented out

#tmpdir = /tmp/

you might want to uncomment that line and see what happens !
 
Old 10-29-2004, 10:39 AM   #5
Malachi Jones
LQ Newbie
 
Registered: Oct 2004
Location: Oklahoma
Distribution: Slackware
Posts: 7

Rep: Reputation: 0
MySQL Blues - "mysql ended"

I am using Slackware 8.0 with MySQL v3.23.39

I installed the binary Slackware package and ran the 'mysql_install_db' as 'root'. When I ran '/usr/bin/safe_mysqld --user=mysql &' the message "mysql ended" appeared. To resolve this I browsed to the '/var/lib/mysql' directory and removed the directories "mysql" and "test".

Then, I created a password for the 'mysql' user (slackware was kind enough to create a password-less user 'mysql' for me). Then, I logged in as 'mysql' and ran 'mysql_install_db'. I then was able to successfully execute '/usr/bin/safe_mysqld --user=mysql &' to start the mysql daemon.

I hope this helps!
 
Old 11-12-2004, 04:06 AM   #6
TheOracle
Member
 
Registered: Nov 2004
Posts: 87

Rep: Reputation: 15
Linux user mysql...

Yes, after some time I found the same.
The DB only starts from Linux user mysql.

Also if you install 4.1.7 from RPM the db starts on boot.
Pick up the pid from /var/lib/localhost.pid
ps -ef | grep ThePidFromFile
You can then check the startup command with datadir, basedir, etc that is used at boot.

Hope this helps
The Oracle
 
Old 08-29-2005, 06:12 PM   #7
reddazz
Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 73
I know this is an old thread, but the solution I'll post may help someone with the same problem as Robin01.[list=1][*]Copy /usr/local/mysql/share/mysql/my-large.cnf to /usr/local/mysql/data.my.cnf[*]Edit /usr/local/mysql/data/my.cnf and add the line tmpdir = /tmp/ to the section called [mysqld] [*]Start mysql by doing "/usr/local/mysql/bin/mysqld_safe --user=mysql &" and it should work fine.[/list=1]
Make sure that the user mysql owns /usr/local/mysql.

Last edited by reddazz; 08-29-2005 at 06:20 PM.
 
  


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
Problem on starting MySql Server Obscure Slackware 4 09-05-2009 07:24 AM
problem starting mysql,new installer addingadam1 Linux - Newbie 3 10-30-2004 12:28 PM
Starting MySQL on fresh Slack install subnet_rx Slackware 7 06-26-2004 04:44 PM
problem starting MYSQL 4.0.1 rixride00 Linux - Software 2 04-06-2004 10:45 AM
Clean Redhat 8.0 install, starting MySQL Fenix Linux - Software 32 02-26-2003 08:02 AM


All times are GMT -5. The time now is 08:53 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration