Arch Linux

jai134

Member

Registered: 2008-11-26

Posts: 234

cant install mysql

Hello. When I try to install MySQL I get this:

chown: invalid user: `mysql'
chown: invalid user: `mysql'
chown: invalid user: `mysql'
Installing MySQL system tables...
101026 20:31:59 [ERROR] Fatal error: Can't change to run as user 'mysql' ;  Please check that the user exists!

101026 20:31:59 [ERROR] Aborting

101026 20:31:59 [Note] /usr/sbin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!

error: command failed to execute correctly
Optional dependencies for mysql
    perl-dbi
    perl-dbd-mysql

When I try     
shell> /usr/sbin/mysqld --skip-grant &
shell> /usr/bin/mysql -u root mysql
I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[1]+  Done                    /usr/sbin/mysqld --skip-grant

What is this? I have never had any problems with installing MySQL before. I need it for a MythTV install. BTW, this is a fresh install made today of Arch Linux.

Last edited by jai134 (2010-10-26 18:57:51)

skunktrader

Member

From: Brisbane, Australia

Registered: 2010-02-14

Posts: 1,543

Re: cant install mysql

I believe you need to change the quote characters - use ` instead of '

awkwood

Member

From: .au <=> .ca

Registered: 2009-04-23

Posts: 91

Re: cant install mysql

When you say "try to install", what command are you actually running?

Are you following the guide on the ArchWiki?

jai134

Member

Registered: 2008-11-26

Posts: 234

Re: cant install mysql

First pacman -Syy then pacman -Suu and finally pacman -S mysql. I have also tried pacman -Rcsn mysql, pacman -Scc and after that a locate mysql to find all dirs holding any files  connected to mysql so I could delete those. Then again pacman -S mysql and now I don't get any error messages during install but I am unable to start the server with /etc/rc.d/mysqld start.