Solved

Cannot connect to MySQL server from anything but command line

Posted on 2003-11-25
10
696 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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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 Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
phpMyAdmin simple sql statement 3 52
MySQL - Restore Database SQL File 5 41
MySQL Grouping 2 23
sql_mode 1 19
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now