Re: [SLE] MySQL upgrade to 4.0.12 gives me troubles]
check the mysql database, it appears you have lost user related information, try from phpMyAdmin or MySQLControlcentre to have a look at what is in the database.. you will have to grant specific permissions for the new users.. I presume, I have also faced similar errors but had to change the accesss rights using mysqladmin (this is described in the Man pages/Manual in troubleshooting section if I remember correctly Vishal Ronald Wiplinger wrote:
I have upgraded MySQL to 4.0.12 into /usr/local/mysql (binary version from www.mysql.org) It works with the new / converted databases fine with the command mysql, but when I try to access via a web site (php) I get a access denied. I
have not
changed password, and again with mysql I can connect to the server.
I made some tests: mysqladmin --protocol=socket --socket=/tmp/mysql.sock version I get protocol socket unknown
Other tests are going well, like mysqladmin -h localhost version
but mysqladmin -h IP# version gives me the same error.
My /etc/my.cnf has socket and port numbers defined.
Any hints?
bye
Ronald
-- Open WebMail Project (http://openwebmail.org)
-- ------------------------------------------------------------------------------- Disparate Needs ------ One Solution --- INETBOX Ampersand Info-Tech Pvt.Ltd phone +91 (0)11 / 2693 3118 New Delhi -- Munich fax +91 (0)11 / 2632 2980 http://www.aitpl.com Linux - Solaris - Windows - Software Application Partners ------------------------------------------------------------------------------- The information contained in this message (including any attachments)is confidential and may be legally privileged. If you are not the intended recipient, please delete it from your system immediately - any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful. AITPL makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained herein or for the transmission, reception, storage or use of such information in any way whatsoever. Any opinions expressed in this message are those of the author and do not necessarily reflect the opinions of AITPL. ------------------------------------------------------------------------------- -- ------------------------------------------------------------------------------- Disparate Needs ------ One Solution --- INETBOX Ampersand Info-Tech Pvt.Ltd phone +91 (0)11 / 2693 3118 New Delhi -- Munich fax +91 (0)11 / 2632 2980 http://www.aitpl.com Linux - Solaris - Windows - Software Application Partners ------------------------------------------------------------------------------- The information contained in this message (including any attachments)is confidential and may be legally privileged. If you are not the intended recipient, please delete it from your system immediately - any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful. AITPL makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained herein or for the transmission, reception, storage or use of such information in any way whatsoever. Any opinions expressed in this message are those of the author and do not necessarily reflect the opinions of AITPL. -------------------------------------------------------------------------------
participants (1)
-
Vishal Khanna