MySQL install troubles.

Eric Jacobs eric at chomp.us
Fri Feb 4 14:23:26 MST 2011


I chowned everything under /usr/local to mysqld:mysqld and now it
actually starts, but I'm not out of the woods yet. Here is what
happens now:
# mysqld --user=mysqld --basedir=/usr/local/
--datadir=/usr/local/var/mysql --skip-grant --verbose
110204 13:45:04  InnoDB: Started; log sequence number 0 44233
110204 13:45:04 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without
them
110204 13:45:04 [ERROR] Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
110204 13:45:04 [Note] mysqld: ready for connections.
Version: '5.1.53'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
Source distribution

I can connect as root and create a database, which is good.

I have run mysql_install_db, and mysql_secure_installation
successfully, but when I attempt to run mysql_upgrade:
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
Running 'mysql_fix_privilege_tables'...
ERROR 1049 (42000): Unknown database 'mysql'
FATAL ERROR: Upgrade failed

Thanks!
Eric


On Fri, Feb 4, 2011 at 1:39 PM, Jeff Schroeder <jeff at zingstudios.com> wrote:
> Eric:
>
>> 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.
>
> Right, because mysql_secure_installation requires that the database be
> running.  So before you run that, you'll need to start the MySQL
> process itself.  That's why you don't see the socket file.
>
>> 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)
>
> All of these errors indicate that MySQL is expecting the database files
> to be in the current directory (./mysql).  I wonder why it's not
> looking in /var/lib/mysql or something instead.  Perhaps one of your
> compile directives set the default data path?
>
> To test this, go into /var/lib and THEN start MySQL-- if this is the
> problem, it should actually work because it'll look for a sub-directory
> called mysql (which now exists where you are).
>
> Jeff
>
> /*
> PLUG: http://plug.org, #utah on irc.freenode.net
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
> */
>


More information about the PLUG mailing list