Home > Archive > PHP SQL > November 2005 > Re: PHP5, MySQL5, Apache2 Startup Problem: Host 'localhost' is not
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: PHP5, MySQL5, Apache2 Startup Problem: Host 'localhost' is not
|
|
| J.O. Aho 2005-11-10, 7:56 am |
| SteadyEddie wrote:
>
> Ok. ive had a setup running mysql before using an install program to learn
> php n mysql. I am now trying to setup the server for myself without
> phpmyadmin ect.
>
> Im using apache 2, mysql 5 and php. I understand that the binaries for mysql
> were not included in php5 so ive downloaded then and have the dlls in the
> php/ext folder with the correct info in the php.ini file.
>
> My apache2 folder is available to the windows PATH as so is the mysql/bin
> and mysql/ folder.
>
> MySql client wont let me log in. and when i try to do it with PHP i get the
> following error:
>
> Attempting Connection:
> Host: localhost User: root + password
> Warning: mysql_connect() [function.mysql-connect]: Host 'localhost' is not
> allowed to connect to this MySQL server in C:\ApacheServer\WebRoot\index.php
> on line 25
This is a "mysql problem" and not PHP, the user "root" aren't allowed to
connect from the same machine as the mysql is running on, you need to alter
the permissions for the user "root", so that it can be logged from localhost
http://dev.mysql.com/doc/refman/5.0/en/create-user.html
http://dev.mysql.com/doc/refman/5.0/en/grant.html
> Attempting Connection:
> Host: localhost User: root
> Fatal error: Call to undefined function mysqli_connect() in
> C:\ApacheServer\WebRoot\index.php on line 32
The PHP you are using is compiled without the mysqli support.
//Aho
|
|
|
|
|