-
编辑 删除
Recover MySQL root Password
Recover MySQL root Passwordby Vivek Gite on April 18, 2006 · 190 commentsYou can recover MySQL database server password with following five easy steps.Step # 1: Stop the MySQL server process....
-
编辑 删除
mysql backup and restore
mysqldump --single-transaction --flush-logs --all-databases > backup_sunday_1_PM.sql
-
编辑 删除
Change the port from 3306 to 8008 for mysql.
The mysql default port is 3306. I want to change the port to 8008. After /etc/my.cnf changed, the mysql can't be started any more. The error message as following.101210 03:47:43 mysqld_safe mysqld fro...
-
编辑 删除
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
错误提示:# mysql -uroot -pEnter password:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)解决方法：1方法一：# /etc/init.d/mysql stop# mysqld_safe --user=mysql --skip...
-
编辑 删除
My sql 远程访问 授权
1、改表法 可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%" mysql -u root -pm...
-
编辑 删除
Create root passoword for Mysql db.
:root > /usr/bin/mysqladmin -u root password '***'You have mail in /var/spool/mail/root:root > mysql -u root -pEnter password: ***
