Login error with mysql/da

[sky]

Hello all

I have just install DA on a new server.
Its seams like the DA users have not got access to mysql. This is the error i get when i try to upload a mysql save via DA mysql manager :

Unable to restore database sky_demo : ERROR 1045 (28000): Access denied for user 'sky'@'localhost' (using password: YES) gunzip: stdout: Broken pipe

I can not either connect to phpmyadmin with the DA users login/pass.

BUT : its all works ok with the da_admin logon...

Another thing strange is that when i create a database, i CAN connect with the login and password of THAT database.

What can i do to so the DA users can access mysql?
Thx

another problem less important is that on the old server, phpmyadmin whas and old version and did not have such a complicated char set manager.
When i import a mysql save, the chars are not all ok ...

like : the à becomes : ?
the ç alsoe becomes ?

Thx for any advice.
Sky

 

[nobaloney]

Generally a broken pipe means the program doesn't have access to the file it's trying to convert/upload.

Check file ownership/permissions as a first step.

Jeff

 

[sky]

Hello jlasman

Ok, i'll look at the permissions.
hum... but what file should i check?

EDIT : ok, i used the file set_permission.sh that is in the script dir of DA. But, nothing as changed.
The probleme is that i cannot connect with any users login/password. even if i try via ssh using : mysql -u login -p password
it only works for da_admin.


its ok for the char set problem, i solvd tyhe problem by using latin1.

thx,
Sky

 

[sky]

I have check the the mysql database, and all the user privilege seam ok.
At least, they are the same as on another DA server i have.

Well, hope someone can help

Sky

 

[DirectAdmin Support]

Hello,

Have you tried resetting your DA password?
Login to DA, change your password, then change it back again. This will also reset the password stored in mysql for that user.

Make sure that you are not using the "login as" feature if using the "upload database" tool, as the password used to login to mysql is the same that is used for the current DA session. If you are using the "login as" feature, then the password stored wouldn't be that of the user, but that of the reseller/admin that created the user, hence the password will be wrong.

Login to DA directly as the user.

The broken pipe message itself is just a result of how the file is restored:

gunzip < file | mysql -uuser -ppass --host=localhost dbname

when mysql quits due to a wrong password, it breaks the pipe between it and gunzip (gunzip wants to keep feeding sql data)

John

 

[sky]

Hello
Thx john for your reply.

I forgot to say that i cant connect via phpmyadmin eyther.

I have just done a test doing what you say, and i get this error :

Unable to restore database admin_fffff : ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

I can only connect to phpmyadmin via da_admin.

Using php, i cant connect either.

ps : i have just tryd the DA script : fix_mysql_privilege => but did not help.

ps2 : i forgot to say that i can connect to mysql via php with da_admin and the user_database login/password.

Sky