Hello.
May be this could be a bit helpful: http://dev.mysql.com/doc/refman/5.0/en/access-denied.html Alastair Roy wrote: > Greetings everyone, I am having a problem with PHP and mysql I have copied a > script exactly off a website to open the database and insert a new user I > try to access the mysql database using the root user, and enter information > into the user table, this is the PHP I am using > > > > <? > include 'library/config.php'; > include 'library/opendb.php'; > > +ACQ-query = "INSERT INTO user (host, user, password, select+AF8-priv, > insert+AF8-priv, > update+AF8- priv) ". > "VALUES ('localhost', 'phpcake', PASSWORD('mypass'), 'Y', 'Y', > 'Y')"; > mysql+AF8-query(+ACQ-query) or die('Error, insert query failed'); > > +ACQ-query = "FLUSH PRIVILEGES"; > mysql+AF8-query(+ACQ-query) or die('Error, insert query failed'); > > include 'library/closedb.php'; > ?> > > > > When I try this I get the access for user root+AEA-local host denied, it is > driving me nuts no matter what I try I get the same thing other scripts I > have tried do the same thing, have tried messing around with the config.php > and opendb.php included scripts but nothing works if I run php -f opendb.php > I get no errors which I think means it is working, then again I don't know. > > > > Anyone have any ideas ?? > > > > Thanks in advance > > > Visit our websites: > > http://www.dailysnack.com +IBw-bite size news and gossip+IB0- > > http://www.express.co.uk The Worlds Greatest Newspaper > > http://www.dailystar.co.uk Simply The Best 7 Days A Week > > http://www.happymagazine.co.uk The One Stop Shopping Magazine > > http://www.ok.co.uk First For Celebrity News > > http://www.northernandshell.co.uk The Mark Of Excellence > > http://www.expresspictures.com Express Newspapers and OK Magazine online > picture archive > > > > > Also visit: > > The NMA: Opening Up Newspapers http://www.nmauk.co.uk > > +ACMAIwAj-2004+ACMAIwAj- > +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8- > Any views or opinions are solely those of the author > and do not necessarily represent those of Express Newspapers > +AF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8AXwBfAF8- > The information transmitted is intended only for the person > or entity to which it is addressed and may contain confidential > and/or privileged material.If you are not the intended recipient > of this message please do not read ,copy, use or disclose this > communication and notify the sender immediately. It should be > noted that any review, retransmission, dissemination or other > use of, or taking action in reliance upon, this information by > persons or entities other than the intended recipient is prohibited. > E-mail communications may be monitored. > +ACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACoAKgAqACo- > > +ACMAIw-EXN2000+ACMAIw- > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
