Solved

Cannot connect to MySQL server from anything but command line

Posted on 2003-11-25
10
709 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

Suggested Solutions

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 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