[PLUG] Resolved: Getting MySQL running
Richard Steffens
rsteff at attbi.com
Sun Dec 22 21:54:03 UTC 2002
Paul Heinlein wrote:
> Look in /var/lib/mysql/$(hostname).err. There are many possible
> causes, a couple of which are
>
> 1. The 'mysql' user doesn't have r/w privs to /var/lib/mysql or the
> files in /var/lib/mysql/mysql. A simple chown will fix you up.
Thanks, Paul. That was the problem. I don't remember having to go
through this before, but it was almost a year ago, and I only had to do
it the one time.
For the benefit of the archives (so I can search for it if I ever need
it again!) here's what I started out with, what I did to change things,
and the result.
--
Regards,
Dick Steffens
http://rsteff.home.attbi.com/
[root at nec /root]# cd /var/lib/mysql
[root at nec mysql]# ls -l
total 16
drwx------ 2 root root 4096 Dec 22 15:13 mysql
srwxrwxrwx 1 mysql mysql 0 Dec 22 16:26 mysql.sock
-rw-r--r-- 1 mysql root 1013 Dec 22 16:26 nec.err
-rw-rw---- 1 mysql mysql 483 Dec 22 15:16 nec.log
drwx------ 2 root root 4096 Dec 22 15:13 test
[root at nec mysql]# chown mysql:mysql *
[root at nec mysql]# ls -l
total 16
drwx------ 2 mysql mysql 4096 Dec 22 15:13 mysql
srwxrwxrwx 1 mysql mysql 0 Dec 22 16:26 mysql.sock
-rw-r--r-- 1 mysql mysql 1013 Dec 22 16:26 nec.err
-rw-rw---- 1 mysql mysql 483 Dec 22 15:16 nec.log
drwx------ 2 mysql mysql 4096 Dec 22 15:13 test
[root at nec mysql]# cd mysql
[root at nec mysql]# ls -l
total 104
-rw-rw---- 1 root root 0 Dec 22 15:13 columns_priv.MYD
-rw-rw---- 1 root root 1024 Dec 22 15:13 columns_priv.MYI
-rw-rw---- 1 root root 8778 Dec 22 15:13 columns_priv.frm
-rw-rw---- 1 root root 302 Dec 22 15:13 db.MYD
-rw-rw---- 1 root root 3072 Dec 22 15:13 db.MYI
-rw-rw---- 1 root root 8982 Dec 22 15:13 db.frm
-rw-rw---- 1 root root 0 Dec 22 15:13 func.MYD
-rw-rw---- 1 root root 1024 Dec 22 15:13 func.MYI
-rw-rw---- 1 root root 8641 Dec 22 15:13 func.frm
-rw-rw---- 1 root root 0 Dec 22 15:13 host.MYD
-rw-rw---- 1 root root 1024 Dec 22 15:13 host.MYI
-rw-rw---- 1 root root 8958 Dec 22 15:13 host.frm
-rw-rw---- 1 root root 0 Dec 22 15:13 tables_priv.MYD
-rw-rw---- 1 root root 1024 Dec 22 15:13 tables_priv.MYI
-rw-rw---- 1 root root 8877 Dec 22 15:13 tables_priv.frm
-rw-rw---- 1 root root 428 Dec 22 15:13 user.MYD
-rw-rw---- 1 root root 2048 Dec 22 15:13 user.MYI
-rw-rw---- 1 root root 9148 Dec 22 15:13 user.frm
[root at nec mysql]# chown mysql:mysql *
[root at nec mysql]# ls -l
total 104
-rw-rw---- 1 mysql mysql 0 Dec 22 15:13 columns_priv.MYD
-rw-rw---- 1 mysql mysql 1024 Dec 22 15:13 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8778 Dec 22 15:13 columns_priv.frm
-rw-rw---- 1 mysql mysql 302 Dec 22 15:13 db.MYD
-rw-rw---- 1 mysql mysql 3072 Dec 22 15:13 db.MYI
-rw-rw---- 1 mysql mysql 8982 Dec 22 15:13 db.frm
-rw-rw---- 1 mysql mysql 0 Dec 22 15:13 func.MYD
-rw-rw---- 1 mysql mysql 1024 Dec 22 15:13 func.MYI
-rw-rw---- 1 mysql mysql 8641 Dec 22 15:13 func.frm
-rw-rw---- 1 mysql mysql 0 Dec 22 15:13 host.MYD
-rw-rw---- 1 mysql mysql 1024 Dec 22 15:13 host.MYI
-rw-rw---- 1 mysql mysql 8958 Dec 22 15:13 host.frm
-rw-rw---- 1 mysql mysql 0 Dec 22 15:13 tables_priv.MYD
-rw-rw---- 1 mysql mysql 1024 Dec 22 15:13 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8877 Dec 22 15:13 tables_priv.frm
-rw-rw---- 1 mysql mysql 428 Dec 22 15:13 user.MYD
-rw-rw---- 1 mysql mysql 2048 Dec 22 15:13 user.MYI
-rw-rw---- 1 mysql mysql 9148 Dec 22 15:13 user.frm
[root at nec lib]# safe_mysqld --user=mysql &
[1] 26668
[root at nec lib]# Starting mysqld daemon with databases from
/var/lib/mysql
[rsteff at nec rsteff]$ ps ax | grep mysql
26668 pts/0 S 0:00 sh /usr/bin/safe_mysqld --user=mysql
26684 pts/0 S 0:00 /usr/libexec/mysqld --basedir=/usr
--datadir=/var/lib
26686 pts/0 S 0:00 /usr/libexec/mysqld --basedir=/usr
--datadir=/var/lib
26687 pts/0 S 0:00 /usr/libexec/mysqld --basedir=/usr
--datadir=/var/lib
26720 pts/1 S 0:00 grep mysql
More information about the PLUG
mailing list