MySQL install troubles.

Eric Jacobs eric at chomp.us
Fri Feb 4 13:30:13 MST 2011


> Any particular reason why the repositories aren't good enough? Seems
> they'd save you a lot of headache..
I would rather compile it from source, I'm not in a big hurry to get
everything up, and I like doing everything from source.

> What user are you running MySQL as?  What user installed/owns the files?
I'm starting mysql with # mysqld --user=mysqld (and the mysqld user
does exist). mysqld owns the executables under /usr/local/bin (mysql
stuff is the only stuff in there at the moment), and mysqld owns
/var/lib/mysql.

> 1) did you run mysql_install_db to initialize the internal mysql db?
> 2) did you do what it says? "run mysql_upgrade"

I did run mysql_install_db and it did appear to succeed.. I didn't see
any errors, anyway. I then proceeded to run mysql_secure_installation
as recommended by mysql_install_db, and it threw errors about not
being able to connect through /var/lib/mysql/mysql.sock.

> Also, you probably need to start it with --skip-grant the first time
> to bypass authentication to set up the mysql root user's password.
This in combination with mysql_install_db yielded the most progress so
far. Here is what I got:
 # mysqld --user=mysqld --skip-grant
110204 13:28:08  InnoDB: Started; log sequence number 0 44233
110204 13:28:08 [ERROR] mysqld: Can't find file:
'./mysql/time_zone_leap_second.frm' (errno: 13)
110204 13:28:08 [Warning] Can't open and lock time zone table: Can't
find file: './mysql/time_zone_leap_second.frm' (errno: 13) trying to
live without them
110204 13:28:08 [ERROR] mysqld: Can't find file: './mysql/servers.frm'
(errno: 13)
110204 13:28:08 [ERROR] Can't open and lock privilege tables: Can't
find file: './mysql/servers.frm' (errno: 13)
110204 13:28:08 [Note] mysqld: ready for connections.
Version: '5.1.53'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
Source distribution

Now it seems to be blocking though. I can't ctrl+z or ctrl+c to get
back to the shell.


Thanks!
Eric


More information about the PLUG mailing list