Welcome Guest, Not a member yet? Register   Sign In
MySql Connection Fail [resolved]
#2

[eluser]jedd[/eluser]
Hi koringa and welcome to the CI forums.


Quote:I can connect from the command line or any others program, for example Sequel Pro for Mysql Database Administration, that is, my database works and is running normally.

Do you connect, at the commandline, using root, or a normal user account?

You should not be using root (as specified in your config.php above) as it's a touch insecure. Create an account for this app, with a different password, etc.

For the time, try this:

Code:
$   mysql  -u root -h localhost -p sitesp

And confirm you can still connect using your credentials.

I'm not sure how OSX works with local connections, but on some *nix's MySQL will connect through sockets rather than through TCP, which can be confusing because MySQL permissions often include the originating host (name or IP). In any case, the above command line might give some more insight into the nature of the problem.


Messages In This Thread
MySql Connection Fail [resolved] - by El Forum - 09-30-2009, 06:23 AM
MySql Connection Fail [resolved] - by El Forum - 09-30-2009, 06:45 AM
MySql Connection Fail [resolved] - by El Forum - 09-30-2009, 09:07 AM
MySql Connection Fail [resolved] - by El Forum - 09-30-2009, 10:45 AM
MySql Connection Fail [resolved] - by El Forum - 09-30-2009, 07:16 PM



Theme © iAndrew 2016 - Forum software by © MyBB