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