1. An error occurred while installing the Mysql *. rpm package.
Error: Failed dependencies:
Perl (CGI) is needed by MySQL-client-4.0.26-0
Perl (DBI) is needed by MySQL-client-4.0.26-0
Error: Failed dependencies:
Perl (DBI) is needed by MySQL-server-4.0.26-0
This is mainly because of the lack of mysql components.
This will not happen to components ~ Yes. Find the following rpm package on the CD and install it.
You can also install myql in Add/delete programs.
Perl DB_File-1.804-88.
Postgresql-libs-7.3.2-3
Postgresql-7.3.2-3
Postgresql-server-7.3.2-3
Perl-CGI-2.81-88.i386.rpm
Test and solve
2. The following problems occur after mysql is started:
[Root @ localhost bin] #./mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/Tmp/mysql. sock' (2)
Solution:
# Chown-R mysql: mysql/var/lib/mysql
[Root @ localhost beinan] #/etc/init. d/mysqld start
Start MySQL: [OK] solved
3. Solve mysql "Access denied for user 'root' @ 'localhost '"
Error 1
Enter password:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password:
YES)
Error 2
# Mysql-uroot-p
Enter password:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password:
NO)
Solution:
Method 1:
#/Etc/init. d/mysql stop
# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &
# Mysql-u root mysql
Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';
Mysql> flush privileges;
Mysql> quit
#/Etc/init. d/mysql restart
# Mysql-uroot-p
Enter password: <Enter the new password newpassword> the test is successful.
Mysql>
Solution 2:
Directly use the username and password provided in the [client] section of the/etc/mysql/debian. cnf file:
# Mysql-udebian-sys-maint-p
Enter password: <Enter the password in the [client] section>
Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';
Mysql> flush privileges;
Mysql> quit
# Mysql-uroot-p
Enter password: <Enter the new password newpassword>
Mysql>
Solution 3: (not tested)
# Mysql-uroot-p
Enter password: <Enter the password provided in [client] in the/etc/mysql/debian. cnf File>