Thread: MySQL problem
View Single Post
  #6  
Old 25th June 2008, 16:41
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default

Hi folks,


I'm in complete lost. The solution for fixing the problem on Ubuntu server 7.04 amd64 can't work on Ubuntu LAMP 6.06 amd64.

After finish on starting MySQL it complains.


# /etc/init.d/mysql start
Code:
Starting MySQL database server: mysqld.
 * Root password is blank.  To change it use:
 * /etc/init.d/mysql reset-password
root@satimis:/home/satimis# /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Finally I have to reinstall MySQL. Steps performed as follows;


$ dpkg -l | grep mysql
Code:
ii  libapache2-mod-auth-mysql   4.3.9-2ubuntu3    	Apache 2 module for MySQL authentication
ii  libdbd-mysql-perl           3.0002-2build1    	A Perl5 database interface to the MySQL data
ii  libmysqlclient15off         5.0.22-0ubuntu6.06.10   mysql database client library
ii  mysql-client-5.0            5.0.22-0ubuntu6.06.10   mysql database client binaries
ii  mysql-common                5.0.22-0ubuntu6.06.10   mysql database common files (e.g. /etc/mysql
ii  mysql-server                5.0.22-0ubuntu6.06.10   mysql database server (current version)
ii  mysql-server-5.0            5.0.22-0ubuntu6.06.10   mysql database server binaries
ii  php5-mysql                  5.1.2-1ubuntu3.10       MySQL module for php5
ii  php5-mysqli                 5.1.2-1ubuntu3.10       MySQL Improved module for php5

$ sudo apt-get remove --purge libapache2-mod-auth-mysq libdbd-mysql-perl libmysqlclient15off mysql-client-5.0 mysql-common mysql-server mysql-server-5.0 php5-mysql php5-mysql
Code:
Password:
....
Need to get 0B of archives.
After unpacking 87.0MB disk space will be freed.
Do you want to continue [Y/n]? Y
.....

Should I remove the complete /var/lib/mysql directory tree which is used by all MySQL versions, not necessarily only the one you are about to purge?                                                   
                                                                                                                            
Remove the databases from all MySQL versions?                                                               
                                                                                                                                                                <Yes>            <No>      

select <No>   

.....
Removing mysql-common ...
Purging configuration files for mysql-common ...
dpkg - warning: while removing mysql-common, directory `/etc/mysql' not empty so not removed.

$ sudo apt-get install mysql-server-5.0 mysql-common
Code:
....
Selecting previously deselected package mysql-common.
(Reading database ... 25445 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.0.22-0ubuntu6.06.10_all.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.22-0ubuntu6.06.10_amd64.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_3.0002-2build1_amd64.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.22-0ubuntu6.06.10_amd64.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.22-0ubuntu6.06.10_amd64.deb) ...
Setting up mysql-common (5.0.22-0ubuntu6.06.10) ...
Setting up libmysqlclient15off (5.0.22-0ubuntu6.06.10) ...

Setting up libdbd-mysql-perl (3.0002-2build1) ...
Setting up mysql-client-5.0 (5.0.22-0ubuntu6.06.10) ...
Setting up mysql-server-5.0 (5.0.22-0ubuntu6.06.10) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.

$ dpkg -l|grep mysql
Code:
ii  libdbd-mysql-perl      3.0002-2build1             A Perl5 database interface to the MySQL data
ii  libmysqlclient15off    5.0.22-0ubuntu6.06.10      mysql database client library
ii  mysql-client-5.0       5.0.22-0ubuntu6.06.10      mysql database client binaries
ii  mysql-common           5.0.22-0ubuntu6.06.10      mysql database common files (e.g. /etc/mysql
ii  mysql-server-5.0       5.0.22-0ubuntu6.06.10      mysql database server binaries

Following packages found missing, not yet installed;
Code:
ii  libapache2-mod-auth-mysql    4.3.9-2ubuntu3          Apache 2 module for MySQL authentication
ii  mysql-server                 5.0.22-0ubuntu6.06.10   mysql database server (current version)
ii  php5-mysql                   5.1.2-1ubuntu3.10       MySQL module for php5
ii  php5-mysqli                  5.1.2-1ubuntu3.10       MySQL Improved module for php5

I have no idea whether "mysql-server" is needed. Because "mysql-server-5.0" is already installed. So I leave it and continue installing;


$ sudo apt-get install libapache2-mod-auth-mysql php5-mysql php5-mysqli
Code:
......
.....
Setting up libapache2-mod-auth-mysql (4.3.9-2ubuntu3) ...
Setting up php5-mysql (5.1.2-1ubuntu3.10) ...

Setting up php5-mysqli (5.1.2-1ubuntu3.10) ...

$ mysql -u root -p
Code:
Enter password: xyz

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-Debian_0ubuntu6.06.10-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> SET PASSWORD FOR root = PASSWORD('xyzadmin');
ERROR 1133 (42000): Can't find any matching row in the user table


mysql> SET PASSWORD FOR 'root' = PASSWORD('xyzadmin');
ERROR 1133 (42000): Can't find any matching row in the user table


mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xyzadmin');
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

$ sudo /etc/init.d/mysql restart
Code:
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.

$ ps ax | grep -i mysql
Code:
 6504 pts/0    S      0:00 /bin/sh /usr/bin/mysqld_safe
 6565 pts/0    Sl     0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
 6566 pts/0    S      0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
 6641 pts/0    S+     0:00 grep -i mysql

MySQL is working now.


Please help me to understand WHY it needs
Code:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xyzdmin');
Query OK, 0 rows affected (0.00 sec)

Why;
Code:
mysql> SET PASSWORD FOR root = PASSWORD('xyzadmin');
ERROR 1133 (42000): Can't find any matching row in the user table


mysql> SET PASSWORD FOR 'root' = PASSWORD('xyzadmin');
ERROR 1133 (42000): Can't find any matching row in the user table
don't work ???


What does
Code:
Query OK, 0 rows affected (0.00 sec)
indicate ???


Do I need installing "mysql-server" additionally to "mysql-server-5.0" ?


TIA


B.R.
satimis

Last edited by satimis; 25th June 2008 at 16:44.
Reply With Quote