Subject: Re: Please help to solve a serios problem

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MySQL++ - Programming with the C++ API to MySQL

MaxDB - Everything about MaxDB, formerly known as SAP DB

ODBC - ODBC with the MySQL Connector/ODBC driver

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	Subject: mysql openssl Question
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	Update one field with more fields from another table
•	Subject: Getting Identity after INSERT
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	mysql test 4 1 fails with the gis test
•	Subject: MySQL Cluster Software
•	Downgrade Mysql from 4 to 3 23
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Can 't access mysql after kernel upgrade
•	Executing MySQL Commands From Within C Program
•	Comparing and writing out BLOBS
•	Subject: Re: Preventing Duplicate Entries
•	FULLTEXT query format question
•	Strange behavior, Table Level Permission
•	Does the binary log enabling affect the MySQL performances?
•	mysql:it 's a db not a dbms how it 's possible?!
•	mysql have same function mthod as Oracle decode()

Subject: Re: Please help to solve a serios problem

Subject: Re: Please help to solve a serios problem

2007-11-06 - By Ali Nebi

Back

-- -- Original Message -- --
From: "Russell E Glaue" <rglaue@(protected)>
To: <anebi@(protected)>
Cc: <mysql@(protected)>
Sent: Tuesday, November 06, 2007 8:55 PM
Subject: Re: Please help to solve a serios problem

>
> The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used
by your
> connecting client may be wrong.
>
> linux$ ls -la /var/lib/mysql/mysql.sock
>
>
> >
> > srwxrwxrwx mysql mysql system_u:object_r:mysqld_var_run_t mysql.sock
>
> So your client would need to connect like so:
>
> linux$ mysql --socket="system_u:object_r:mysqld_var_run_t
mysql.sock" --user=user -p
>
> What OS are you running MySQL on?
>
> -RG

Thanks for the reply.
> Does the file exist?
Yes, i see that the file exist.
> You say this is the sock file created by mysqld:
when mysqld daemon is stopped the mysql.sock file not exist, when we run
/etc/init.d/mysqd (this is mysql.server), it start mysql_safe and create
mysql.sock under /var/lib/mysql/.

> linux$ mysql -- socket="system_u:object_r:mysqld_var_run_t
mysql.sock" --user=user -p

We don't need to use socket option because in /etc/my.cnf we have set where
is mysql.sock file. By this way when we start mysql server, mysql client
already know where is mysql socket. I suppose this is correct, if not please
correct me.

We are using CentOS 5, 64 bits version.

Also this:
system_u:object_r:mysqld_var_run_t.
It is not need to be set in sock="", because these are SELinux permissions,
this is different.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)