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
Solved

Cannot connect to MySQL server from anything but command line

Posted on 2003-11-25
10
705 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

837 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