Solved

Cannot connect to MySQL server from anything but command line

Posted on 2003-11-25
10
701 Views
Last Modified: 2008-02-01
I have switched from one server running MySQL running 3.x to a server running 4.0.16 and cannot connect to it with anything except the command line through telnet. I keep getting "access denied" messages. Even if I set up another user with all permissions and try to connect with that user, it does not work. I have tried using apps to connect to it from my PC like Access and Mascon. I also have install apps like phpMyAdmin and a shopping cart on the server and set them to try "localhost" and the IP address but they cannot reach it either.

Help!

MJL
0
Comment
Question by:mjinxed
  • 5
  • 4
10 Comments
 
LVL 17

Expert Comment

by:Squeebee
ID: 9820436
What specific error message do you get?

When you set-up a user with all permissions, did you also allow access from all hosts?
0
 

Author Comment

by:mjinxed
ID: 9821065
If I try to connect with Mascon, I get the error "Could not connect using: user@ip" where user@ip are the user name I am trying to connect with and the IP address of the server I am trying to connect to.

With my shopping cart, I get the following:

DBI connect('host=localhost;database=ccp51','mikel',...) failed: Access denied for user: 'user@localhost' (Using password: YES) at /library/common/database.pl line 366

where "user" is the name of the user I am trying to connect with.

Yes, my user is set up in webmin under database permissions like so:

DATABASE - any USER - username HOSTS - any PERMISSIONS - all

MJL
0
 
LVL 17

Expert Comment

by:Squeebee
ID: 9821086
If I saw that error message I would say that either my password is incorrect or my host permission is wrong. That or anonymous users are wreaking havoc on your permission checking... What do the contents of your user table look like?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 1

Expert Comment

by:Vihmapuu
ID: 9826107
Did you try GRANT command from command line?
See MySQL documentation for more information.
To allow access from any IP address, you would have to do like this:
GRANT ALL PRIVILEGES ON *.* TO user@"%" IDENTIFIED BY "password";
Please note "%" in double quotes that makes MySQL accept connections from any IP.
0
 

Author Comment

by:mjinxed
ID: 9853680
mysql> grant all privilages on *.* to ccpsql@"%" identified by "ITypedMyPasswordInsideQuotes";
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'privilages on *.* to ccpsql@"%" identified by "ITypedMyPasswordInsideQuotes"' at li

MJL
0
 
LVL 17

Expert Comment

by:Squeebee
ID: 9855644
grant all on *.* to 'ccpsql'@'%' identified by 'ITypedMyPasswordInsideQuotes';
0
 

Author Comment

by:mjinxed
ID: 9859312
mysql> grant all on *.* to 'ccpsql'@'%' identified by 'ITypedMyPasswordInsideQuotes';
Query OK, 0 rows affected (0.03 sec)

When I try to connect to the server via Mascon using the ip address on port 3306, I get the following error:

Error: Could not connect using: ccpsql@my.ip.address.here

Am I losing my mind here? It was not this difficult last time I set this up....

MJL
0
 

Author Comment

by:mjinxed
ID: 9859428
The server seems to work fine with anything on it that uses 'localhost' but anything that needs to connect remotely using the IP address or the domain name does not work.

MJL
0
 
LVL 17

Accepted Solution

by:
Squeebee earned 100 total points
ID: 9860946
Is a firewall blocking the connection?
0
 

Author Comment

by:mjinxed
ID: 10373463
I don't remember the solutiojn but I remember you helped me find it so thank you!

MJL
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question