[SOLVED] Installing webserver. Problem with mysql.

kdemon · 2008-12-11 17:38:49

Hi, everyone! So I am building webserver and hoping for some help from you.
I was following this tutorial
http://wiki.archlinux.org/index.php/LAMP
and everything is going fine until I get to MYSQL installation process.
I try to start it --> /etc/rc.d/mysql start
It gets BUSY and FAIL.

The thing is that Apache and PHP is working, I can place a code under /home/user/public_html and its working, but I cant get MYSQL up.

Oh, and I'm doing this as root if that helps.

Last edited by kdemon (2008-12-12 00:53:14)

kdemon · 2008-12-11 18:04:38

Ok, so I checked log file mysqld.log and its empty, also checked messages.log and syslog.log - nothing.

kdemon · 2008-12-11 19:09:03

seriously guys... need help

tankmcp · 2008-12-11 19:16:28

Did you try to start with /etc/rc.d/mysql start ?
I think it should be /etc/rc.d/mysqld start
Hope this helps.

kdemon · 2008-12-11 19:44:28

My mistake, yes i was starting it like this -> /etc/rc.d/mysqld start

kdemon · 2008-12-11 19:56:33

I found that log file where is something about mysql is /var/lib/mysql/localhost.err
And there:

InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
mysql ended

What is that directory to which I dont have permissions? I ran the command as root, doesnt that mean, that there shoudnt be any permission errors?

kdemon · 2008-12-11 20:16:57

I just entered "mysql_secure_installation" and when I am asked to input root password I get this:
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

Maybe it's with those permissions?

haxit · 2008-12-11 21:53:58

Are you sure your root? (Just checking)

kdemon · 2008-12-11 22:21:53

Yes. Well its written "root". I dont know . I'm quite new to Linux.... But seriously - yes - I'm root

finferflu · 2008-12-11 22:28:33

It might be worth checking this out. I found it googling the first line of the error you got *hint hint*

kdemon · 2008-12-11 22:56:34

Yes! Many thanks! It really helped, now I have mysqld running...

Last edited by kdemon (2008-12-11 23:00:12)

kdemon · 2008-12-11 23:50:52

Ok, now I think I have a problem with adding root account. After running

"mysql -p -u root"

I got

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

As I saw Here , I had HOSTNAME="localhost" in rc.conf. I changed it to "khost". Also I added khost in /etc/hosts file -> "127.0.0.1 localhost.localdomain localhost khost". I removed mysql with pacman -Rsn switch and reinstalled it. But still no go. I can start mysqld now very nicely. But after running "mysql -p -u root" It drops me the same error as before.

Last edited by kdemon (2008-12-12 00:54:36)

kdemon · 2008-12-12 00:44:12

I solved this with entering command "hostname khost". So, is there a difference between comand "hostname khost" and changing hostname in etc/rc.conf and etc/hosts files?
So I moved on. I ran mysql_install_db ---> success and finaly mysql_secure_installation with a help of this thread.
Cant say how happy I am to finaly enter root password

kdemon · 2008-12-12 00:48:37

Big thanks to tankmcp, haxit and finferflu for input. Hope this thread will help others. Putting as SOLVED

finferflu · 2008-12-12 18:19:43

Glad it helped

Arch Linux

#1 2008-12-11 17:38:49

[SOLVED] Installing webserver. Problem with mysql.

#2 2008-12-11 18:04:38

Re: [SOLVED] Installing webserver. Problem with mysql.

#3 2008-12-11 19:09:03

Re: [SOLVED] Installing webserver. Problem with mysql.

#4 2008-12-11 19:16:28

Re: [SOLVED] Installing webserver. Problem with mysql.

#5 2008-12-11 19:44:28

Re: [SOLVED] Installing webserver. Problem with mysql.

#6 2008-12-11 19:56:33

Re: [SOLVED] Installing webserver. Problem with mysql.

#7 2008-12-11 20:16:57

Re: [SOLVED] Installing webserver. Problem with mysql.

#8 2008-12-11 21:53:58

Re: [SOLVED] Installing webserver. Problem with mysql.

#9 2008-12-11 22:21:53

Re: [SOLVED] Installing webserver. Problem with mysql.

#10 2008-12-11 22:28:33

Re: [SOLVED] Installing webserver. Problem with mysql.

#11 2008-12-11 22:56:34

Re: [SOLVED] Installing webserver. Problem with mysql.

#12 2008-12-11 23:50:52

Re: [SOLVED] Installing webserver. Problem with mysql.

#13 2008-12-12 00:44:12

Re: [SOLVED] Installing webserver. Problem with mysql.

#14 2008-12-12 00:48:37

Re: [SOLVED] Installing webserver. Problem with mysql.

#15 2008-12-12 18:19:43

Re: [SOLVED] Installing webserver. Problem with mysql.

Board footer