Linux connecting to mysql PHP

Question

I have been trying to connect to mysql all evening using PHP. I know for a fact the username and password are correct as I have tried 3/4 and I know the permissions are set correctly in the database.

If I remote onto this machine and enter the exact same details into the commandline then i can connect to the database without issue.

The problem only seems to be with MYSQL and PHP.

A little more info:

I am trying to run a PHP app on the same server as the mysql database is on. The user has full grant permissions on the local machine. The error i am receiving is :

Fatal error: Attempt to connect to database kmc_cms on

The server is set so no remote access to mysql is available.

What error is mysql / php returning after doing a mysql_connect? — Patrick Evans, Jan 07 '12 at 16:56
Can you connect remotely using the command line? Maybe you only have GRANTs on localhost. — cmbuckley, Jan 07 '12 at 16:58
Please give the complete error and the connect code. Perhaps you are able to connect to MySQL but not able to connect to the database? — Abhay, Jan 07 '12 at 18:23

score 1 · Answer 1 · answered Jan 07 '12 at 17:08

1

In your question you don't show whether you're trying IP or localhost.

Do a

show grants for <username>;

and see if the connection you're trying is even allowed.

answered Jan 07 '12 at 17:08

ethrbunny

10,379
9
69
131

Appologies I am trying localhost, though I have also tried the ip of the server also – Matt Seymour Jan 07 '12 at 17:14
Which DB library? Sample code? Full text of the error message? – ethrbunny Jan 07 '12 at 17:28

score 0 · Answer 2 · answered Jan 07 '12 at 16:56

0

Have you enabled remote access for the user you're trying to connect with in mysql?

answered Jan 07 '12 at 16:56

Mithrandir

24,869
6
50
66

score 0 · Accepted Answer · answered Jan 09 '12 at 09:45

I found out the issue. Within the mysql database config file there was an error which resulted in the connection allowing users from local host access only. Even though the PHP scripts were connecting using localhost it just would not authenticate. Hence I could log in using command line and not using PHP or other applications.

Linux connecting to mysql PHP

3 Answers3