Problem with mysql

[dr_rude]

Good day,

i've got the error msg saying :-

can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

i created the root password using :-

mysqladmin -u root password mynewpassword

it works fine, but i tried to connect my php script with the mysql database that error msg appeared at my firefox browser.

help me.

[ewdi]

that means mysql is not running, try run it on /etc/rc.d/init.d/mysqld

[dr_rude]

i tried twice to turn it on thru command line at
/etc/rc.d/init.d/ by issuing the /etc/rc.d/init.d/mysqld start

it works fine but i still get that error msg.

i go to system settings-server-settings-services,

mysqld servies was running!

plz guide me thru.

[netblues]

First of all try connecting with comand line client
type mysql
and then show databases;
If you see some tables then mysql is up and running.
however you also have to specify mysql connection parameters in php.ini
by default in /etc/php.ini
there is a mysql section....

[dr_rude]

good day netblues,

i can access mysql databases thru cmd line very well.
there's no problem.

if there's little configuration in php.ini? [/etc/php.ini]
then how? i know there's section for mysql, but i leave it as defaults.

someone help me plz.

[zjimward]

My MySql does not start at all, it fails since the update:

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

/var/log/mysqld.log Shows:

050110 10:03:37 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
050110 10:03:37 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
050110 10:03:37 mysqld ended

Every thing was working fine until I updated to 3.23.58-14. Any one have a solution?

[brahms]

This is an SELinux issue. As root:

cd /var/lib/mysql
ls -lZ

You'll probably see that the mysql sub-directory has the wrong security context. Fix it with:

chcon -R -t mysqld_var_run_t mysql

Should start now with:

service mysqld start

[zjimward]

Originally Posted by brahms

This is an SELinux issue. As root:

cd /var/lib/mysql
ls -lZ

You'll probably see that the mysql sub-directory has the wrong security context. Fix it with:

chcon -R -t mysqld_var_run_t mysql

Should start now with:

service mysqld start

Thanks this solution worked great for me.

Why do these type of selinux issues effects me when I have it disabled?

[dr_rude]

good day,

i issued the "chcon -R -t mysqld_var_run_t mysql" as root but i the error msg saying:-

chcon: failed to change context of mysql/tables_priv.frm to root:object_r:mysqld_var_run_t: Invalid argument
chcon: failed to change context of mysql/func.MYD to root:object_r:mysqld_var_run_t: Invalid argument
and so on.

why?

i installed the fedora core 3 with SE Linux options.

what should i do now? i love tis box, and i don't want ot reinstall it again. Or maybe i try to upgrade my mysql server? Or is there any solutions? Plz.... help me.

[brahms]

Please post the output of

ls -lZ  /var/lib/mysql/

and

ls -lZ  /var/lib/mysql/mysql/

You will need to be root for this listing.

[zjimward]

As a side note I also had to run:

"chcon -R -t mysqld_var_run_t"

on my database directories as well.

[dr_rude]

Good day,

Here is the dir listing

[dr_rude@kppk ~]$ su
Password:
[root@kppk dr_rude]# cd /var/lib/mysql/
[root@kppk mysql]# ls lZ
ls: lZ: No such file or directory
[root@kppk mysql]# ls -lZ
drwx------ mysql mysql user_u:object_r:var_lib_t forum
drwx------ mysql mysql root:object_r:var_lib_t mysql
srwxrwxrwx mysql mysql user_u:object_r:var_lib_t mysql.sock
drwx------ mysql mysql root:object_r:var_lib_t test
[root@kppk mysql]# chcon -R -t mysqld_var_run_t
chcon: too few arguments
Try `chcon --help' for more information.
[root@kppk mysql]#
[root@kppk mysql]# cd mysql
[root@kppk mysql]# ls -lZ
-rw-rw---- mysql mysql root:object_r:var_lib_t columns_priv.frm
-rw-rw---- mysql mysql root:object_r:var_lib_t columns_priv.MYD
-rw-rw---- mysql mysql root:object_r:var_lib_t columns_priv.MYI
-rw-rw---- mysql mysql root:object_r:var_lib_t db.frm
-rw-rw---- mysql mysql root:object_r:var_lib_t db.MYD
-rw-rw---- mysql mysql root:object_r:var_lib_t db.MYI
-rw-rw---- mysql mysql root:object_r:var_lib_t func.frm
-rw-rw---- mysql mysql root:object_r:var_lib_t func.MYD
-rw-rw---- mysql mysql root:object_r:var_lib_t func.MYI
-rw-rw---- mysql mysql root:object_r:var_lib_t host.frm
-rw-rw---- mysql mysql root:object_r:var_lib_t host.MYD
-rw-rw---- mysql mysql root:object_r:var_lib_t host.MYI
-rw-rw---- mysql mysql root:object_r:var_lib_t tables_priv.frm
-rw-rw---- mysql mysql root:object_r:var_lib_t tables_priv.MYD
-rw-rw---- mysql mysql root:object_r:var_lib_t tables_priv.MYI
-rw-rw---- mysql mysql root:object_r:var_lib_t user.frm
-rw-rw---- mysql mysql root:object_r:var_lib_t user.MYD
-rw-rw---- mysql mysql root:object_r:var_lib_t user.MYI
[root@kppk mysql]#

Hope tis help.

[brahms]

OK. Issue this command as root:

chcon -R -t mysqld_var_run_t /var/lib/mysql/*
service mysqld restart

It will work now.

NB: chcon is the chmod for security contexts. Just like chmod, it needs to be told which file to affect. That's why you got the "too few arguments" error. Have a read of the "man chcon" pages.

[dr_rude]

good day brahms,

still no luck for me.
when i issued the "chcon -R -t mysqld_var_run_t /var/lib/mysql/*" comand,
i got the error saying "chcon: too few arguments"

[zjimward]

Originally Posted by dr_rude

good day brahms,

still no luck for me.
when i issued the "chcon -R -t mysqld_var_run_t /var/lib/mysql/*" comand,
i got the error saying "chcon: too few arguments"

I'm just wondering if you are putting a space between mysqld_var_run_t and
/var/lib/mysql/*

Only because that would cause there to many a message that says:
chcon: too few arguments