Trouble in paradise...

Hi,

I am allready since some time a happy ISPconfig user and mostly everything runs smootly, but this morning I wanted to create a MySQL database via the ISPconfig site, and something went wrong, I dont know what everything seems te be okay, but when I loged out of the ISPConfig and tried to re-login it gives me the following message...

Anybody have a clue ghow to solve this ?

Thanks in advance,
Etienne (web-worlds)

 

Backtracing my steps I think that I know what happened...

I created a database for a site where I named the DB owner root, with the root password, then I removed the database, so I am afraid that I also deleted the root database user, because also via phpMyAdmin I cannot
login anymore as root ...


HELP

Etienne (web-worlds)

 

Anybody that can help out ???

Thanks in advance
Etienne (web-worlds)

 

Hi Till,

Thanks for your reply, yes I did it in ISPConfig, I am willing to recreate it, but I still cant get into my MySQL, here is what I did:

In a terminal window:

Code:

 /etc/init.d/mysql stop

It tells me that the service is stopped, and I type:

Code:

mysqld_safe --skip-grant-tables

It then tells me:

Then it doesnt show a prompt, but I can go on, so I type:

Code:

 mysql -u root

Then it tells me 'Welcome t mySQL monitor etc, and I type:

Code:

use mysql;

It tells me that it changed the database, so I type:

Code:

update user set password=PASSWORD("new-password") where User='root';

It tells me:

So I type:

Code:

flush privileges;

Then it tells:

Then I type:

Code:

quit

It then quits the MySQL monitor and brings me back to prompt, there I type:

Code:

/etc/init.d/mysql stop

It then tells me that MySQL safe is stopped, and I type:

Code:

 /etc/init.d/mysql start

It then starts the MySQL service, then I type:

Code:

   mysql -u root -p

Then it asks me for the password, I type the password that I just set, and it tells me:

And I end up with the prompt

What do I do wrong???

Thanks in advance,
Etienne (web-worlds)

 

Oef...

And how will I do that, can you assist me in this ?

Kind regards,
Etienne