Re: Can't open privilege tables/mysql.sock

2005-07-11 Thread Tim Johnson 
* Gleb Paharenko [EMAIL PROTECTED] [050711 07:17]:
 
 Hello Gleb:
 Check that you have correct permissions set on MySQL datadir.
 See:
   http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
 
  I will add to the comments above. I had to set the owner
  and group to mysql as per my redhat setup.

  More problems tho:
  ==
  When invoking mysql, I get the following error message:
  
  Can't connect to local MySQL server through socket at
  'var/lib/run/mysql/mysql.sock'
  

  hmm! mysql.sock was created at var/lib/mysql. 
  owner=mysql, permissions=777
  So again, is there paths/permissions problems?
  The following is in /etc/my.cnf
  --
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-
  
Thank you for your help so far. 
Further support greatly appeciated. :-)

Further pointers to docs invited!

Regards
Tim
  Using 4.0.20 on Slack 10.0
  
  New setup. mysql_install_db was run.
  On startup, the error log shows the following error message:
  
  Fatal error: Can't open privilege tables: Can't find file:
  './mysql/host.frm' (errno: 13)
  
  It would appear the paths are not being set. 
  
  -
  Need advice on what to do next. URLs of documentation would
  be appreciated as well.
  -
  
  When I ran mysql_install_db, part of the message displayed
  at that time was:
  
  To start mysqld at boot time you have to copy support-files/mysql.server
   to the right place for your system
  
  And I'm sorry to say, but I don't know what that means. duh
  
  Again, advice and clarification of these instructions are welcome.
  Thanks
  tim
  
 
 
 -- 
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.NET http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
___/   www.mysql.com
 
 
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
Tim Johnson [EMAIL PROTECTED]
  http://www.alaska-internet-solutions.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't open privilege tables/mysql.sock

2005-07-11 Thread gerald_clark 

Tim Johnson wrote:


* Gleb Paharenko [EMAIL PROTECTED] [050711 07:17]:

Hello Gleb:
 


Check that you have correct permissions set on MySQL datadir.
See:
 http://dev.mysql.com/doc/mysql/en/mysql-install-db.html
   



 I will add to the comments above. I had to set the owner
 and group to mysql as per my redhat setup.

 More problems tho:
 ==
 When invoking mysql, I get the following error message:
 
 Can't connect to local MySQL server through socket at
 'var/lib/run/mysql/mysql.sock'
 

 hmm! mysql.sock was created at var/lib/mysql. 
 owner=mysql, permissions=777

 So again, is there paths/permissions problems?
 

Since this is where your my.cnf says to put it, it would be a problem if 
it was not there.
If you are going to override the default location of the socket for the 
server,

you will also need to add an entry for the client.

[mysql]
socket=/var/lib/mysql/mysql.sock


 The following is in /etc/my.cnf
 --
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-
 
Thank you for your help so far. 
Further support greatly appeciated. :-)


Further pointers to docs invited!

Regards
Tim
 




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't open privilege tables/mysql.sock

2005-07-11 Thread Tim Johnson 
  hmm! mysql.sock was created at var/lib/mysql. 
  owner=mysql, permissions=777
  So again, is there paths/permissions problems?
  
 
 Since this is where your my.cnf says to put it, it would be a problem if 
 it was not there.
 If you are going to override the default location of the socket for the 
 server,
 you will also need to add an entry for the client.
 
 [mysql]
 socket=/var/lib/mysql/mysql.sock

  ... of course ... duh
  That's what I needed.
  
  (the my.cnf was copied from a RH 9.0 partition with
   mysql 3.23.58)
  
  Well done!
  thanks
  tim
  
-- 
Tim Johnson [EMAIL PROTECTED]
  http://www.alaska-internet-solutions.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]