|
|
Posted by SteadyEddie on 11/11/05 11:48
How do I Grant the permissions? It wont let me log in to change them???
"J.O. Aho" <user@example.net> wrote in message
news:3tgnhdFst1aoU1@individual.net...
> 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.
>
>
>
> file://Aho
>
Navigation:
[Reply to this message]
|