Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Thursday, March 13, 2008

Install mysql-devel package in debian

When you install ISPconfig, it requires the library of mysql-devel, I have been looked many forum to get exactly the package name.
let's run command:
apt-get install libmysqlclient15-dev

Wednesday, March 05, 2008

Quên mật khẩu root của MySQL

First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.

mysqld_safe --skip-grant-tables

You should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.

mysql --user=root mysql

update user set Password=PASSWORD('new-password');
flush privileges;
exit;

Now kill your running mysqld, then restart it normally. You should be good to go. Try not to forget your password again.