mysqlݿǹĿǰȽеݿˣʺϸ͵ĿԱʹãȻڹҲǷdzеģʹmysqlݿҪְ汾ԼصĹʹõģ
mysqlݿô
һ:
my.ini[mysqld]ֶμ룺
skip-grant-tables
mysqlʱmysqlҪ뼴ɵ¼ݿ
Ȼmysql
mysql>use mysql;
mysql> user set password=password('') WHERE User='root';
mysql>flush privileges;
֮ȥmy.iniеskip-grant-tablesmysqldɡ
:
ʹmy.iniķͨǷʽskip-grant-tablesmysqlmysql
ֹͣmysql
дڣbinĿ¼ʹmysqld-nt.exeдִ: mysqld-nt --skip-grant-tables
Ȼһдڣ¼mysqlʱmysql뼴ɽ롣
Ϸĺ,رmysqlǸڣʱرmysqlmysqlеĻԽӦرաmysql
mysqlݿôsqlļ
ȴcmdٽmysqlbinĿ¼
cd D:\soft\wamp\bin\mysql\mysql5.0.51b\bin س
mysql -u û -p س
source d:\abc.sql ָԼĿ¼س
mysqlôжظɾ жط
1 ֹͣMySQL
2 -жسжеMySQL
3 ҵMySQLװĿ¼ɾ
ذװ·Ϊ
D:\Program Files\MySQL
D:\ProgramData\MySQL
4ҵMySQLڵĿ¼mysqlΪؼֶ̨Խɾ:
C:\Users\zhenghaishu\AppData\Roaming\MySQL
C:\Users\zhenghaishu\AppData\Local\Temp\MySQL Workbench
C:\Users\zhenghaishu\AppData\Roaming\Oracle\MySQL Notifier
5 鿴עɾɡ
HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Application/MySQL
HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Application/MySQL
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Application/MySQL