Posted by J.O. Aho on 11/10/05 12:59

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

[Back to original message]