[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