Re: No connect to mysql
Hi, I have solved .. I have writed in 'Index' file: cp1251 83 still thanks, thanks gelbs !!. :-)) Salvatore. - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 16, 2004 6:39 PM Subject: Re: No connect to mysql > Hello. > > [EMAIL PROTECTED] charsets]$ perror 142 > MySQL error: 142 = Unknown character set used > > You should follow the recommendations at: > http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html > > What output does the following command produce? > myisamchk -dvv host.MYI > Have you upgraded? > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: No connect to mysql
"Gleb Paharenko" wrote: > What output does the following command produce? > myisamchk -dvv host.MYI the result is: myisamchk: File '/usr/share/mysql/charsets/italian.conf' not found (Errcode: 2) myisamchk: Character set '#'83' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file myisamchk: error: 142 when opening MyISAM-table 'host.MYI' .. in the my 'Index' file isn't present 83, but as I make to insert charset the 83 in the 'Index' file ? thing I must to write in the Index file ?? thanks. Salvatore. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: No connect to mysql
Hello. [EMAIL PROTECTED] charsets]$ perror 142 MySQL error: 142 = Unknown character set used You should follow the recommendations at: http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html What output does the following command produce? myisamchk -dvv host.MYI Have you upgraded? "sasa" <[EMAIL PROTECTED]> wrote: > Hi, I have the following permission: > #ls -l /var/lib/ > drwxr-xr-x 4 mysql root .. mysql > > .. in the mail.err: > /usr/sbin/mysqld: Cant't open file: 'host:MYI'. (errno: 142) > Fatal error: Can't open privilege tables: File = > '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) > > and: > #ls -l /var/lib/mysql/mysql/host.MYI > -rw-- 1 mysql root > > ..sorry but the message correct is: > > error: Can't connect to local MySQL server through socket = > '/var/lib/mysql/mysql.sock (2)' > Check that mysql is running and that the socket: = > '/var/lib/mysql/mysql.sock' exists ! > > ..and I have tried to create mysql.sock but I don't have good result. > What I can to do for to resolve my problem ?? > thanks. > Salvatore. > > - Original Message -=20 > From: "sasa" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, December 14, 2004 12:41 PM > Subject: No connect to mysql > > > Hi, I have a problem with mysql 4.0.22 on fedora core 2. > ..when I try: > > #/usr/bin/mysqladmin -u root password '' > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: Can't connect to local MySQL server through socket = > '/var/lib/mysql.sock (2)' > Check that mysql is running and that the socket: '/var/lib/mysql.sock' = > exists ! > > .. the file mysql.sock not exists but I can to resolve ? > .. thanks and sorry for my banal question. > Salvatore. > > > > -- 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]
Re: No connect to mysql
"J.R. Bullington" wrote: > Make sure that you have run `#/usr/local/mysql/bin/safe_mysqld &` ..when I try: #/usr/bin/safe_mysqld & [1] #Starting mysqld daemon with database from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mail.pid 041215 23:56:46 mysqld ended and: #/usr/bin/mysqladmin status /usr/bin/mysqladmin: connect to server at 'localhost' failed error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock (2)' Check that mysql is running and that the socket: '/var/lib/mysql.sock' exists ! thanks. Salvatore. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: No connect to mysql
Hi, I have the following permission: #ls -l /var/lib/ drwxr-xr-x 4 mysql root .. mysql .. in the mail.err: /usr/sbin/mysqld: Cant't open file: 'host:MYI'. (errno: 142) Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) and: #ls -l /var/lib/mysql/mysql/host.MYI -rw-- 1 mysql root ..sorry but the message correct is: error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock (2)' Check that mysql is running and that the socket: '/var/lib/mysql/mysql.sock' exists ! ..and I have tried to create mysql.sock but I don't have good result. What I can to do for to resolve my problem ?? thanks. Salvatore. - Original Message - From: "sasa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 14, 2004 12:41 PM Subject: No connect to mysql Hi, I have a problem with mysql 4.0.22 on fedora core 2. ..when I try: #/usr/bin/mysqladmin -u root password '' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: Can't connect to local MySQL server through socket '/var/lib/mysql.sock (2)' Check that mysql is running and that the socket: '/var/lib/mysql.sock' exists ! .. the file mysql.sock not exists but I can to resolve ? .. thanks and sorry for my banal question. Salvatore. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: No connect to mysql
The reason that you cannot connect is that your MySQL server is not running. Make sure that you have run `#/usr/local/mysql/bin/safe_mysqld &` First and then try to run mysqladmin. The other option is to run `#/usr/local/bin/mysqladmin status` to check to see if the server is running. J.R. -Original Message- From: sasa [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 6:42 AM To: [EMAIL PROTECTED] Subject: No connect to mysql Hi, I have a problem with mysql 4.0.22 on fedora core 2. ..when I try: #/usr/bin/mysqladmin -u root password '' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: Can't connect to local MySQL server through socket '/var/lib/mysql.sock (2)' Check that mysql is running and that the socket: '/var/lib/mysql.sock' exists ! .. the file mysql.sock not exists but I can to resolve ? .. thanks and sorry for my banal question. Salvatore. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]