Hi folks,
Solved the problem on reinstalling MySQL with aptitude.
$ sudo aptitude install mysql-server mysql-client
Code:
.....
.....
Setting up libdbd-mysql-perl (3.0008-1build1) ...
Setting up mysql-client-5.0 (5.0.38-0ubuntu1.4) ...
Setting up mysql-server-5.0 (5.0.38-0ubuntu1.4) ...
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
* Root password is blank. To change it use:
* /etc/init.d/mysql reset-password
Setting up mysql-client (5.0.38-0ubuntu1.4) ...
Setting up mysql-server (5.0.38-0ubuntu1.4) ...
Now MySQL starts without problem.
Run
$ dpkg -l | grep mysql
to compare the packages installed with those removed previously. Found following packages missing;
mysql-admin
mysql-admin-common
libmysqlclient15-dev
php5-mysql
Run aptitude to install them.
I think the only reason of failure previously in running "apt-get install" is apt not taking care of dependencies.
$ mysql -uroot mysql
Code:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.38-Ubuntu_0ubuntu1.4-log Ubuntu 7.04 distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>quit
Bye
MySQL is working now.
$ sudo mysqladmin -u root password abcde
No complaint.
$ sudo mysqladmin -u root -h localhost password xyz
Code:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I doubt whether it needs running this command???
$ sudo /etc/init.d/mysql restart
Code:
Password:
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
MySQL is working normal now.
B.R.
satimis
Bookmarks