Hi, When you're connecting from your PHP script, are you connecting from the same machine that the db is on, or a different one? If a different one, you'll need to do grant commands like: grant all privileges on mydbname.* to 'mydbuser'@'myhostname.mycompany.net' identified by 'mypassword'; Ted On 3/2/07, Roberto F Tavares Neto <tavares@xxxxxxxxxxxxx> wrote:
Ted, I try the classic "abc" and had the same problem... Roberto Ted Fines escreveu: > Hi, > > So it works from PHP w/o a password, but with a password does not? > What are > you using for a password? I don't mean post it here, but are there any > 'funny' characters in it? I've had trouble because of that before, on > other > systems. Try a dumb, obviously OK password, like 'apples' and see if > that > works. Increase the password complexity from there... > > Ted > > On 3/2/07, Roberto F Tavares Neto <tavares@xxxxxxxxxxxxx> wrote: >> >> Hello, >> >> I'm trying to do a very simple thing: create a database and a user to >> use it. >> >> So, initially, I use the web interface phpmyadmin. Logged as root, I >> created the database, and the user with some password. >> >> But, I could not login using phpmyadmin. Either any php-based system >> could connect to the BD. >> >> So, I make sure that I got the "user@localhost" and "user@%" created, >> with permissions and same password. Nothing. >> >> But I *can* log on mysql shell. >> >> One more info: when the user is set without password, it works fine on >> PHP. >> >> >> Does anyone can give me a clue of what is happening? >> >> Thanks! >> >> Roberto >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > -- ------------------------------------------------------------------------------------ Roberto Fernandes Tavares Neto Prof. Assistente Departamento de Engenharia de Produção Universidade Federal de São Carlos tavares@xxxxxxxxxxxxx <mailto:tavares@xxxxxxxxxxxxx> tel +55 16 3351-9240 http://www.dep.ufscar.br/docentes_desc.php?uid=165 ------------------------------------------------------------------------------------
