MYSQL????????
posted 四月 3rd, 2009 by ?????
????phpmyadmin???????????mysql??user?????????PASSWORD???
?????
????mysqladmin?????????????
??mysqladmin -u root -p password mypasswd
??????????????root???????root??????mypasswd?
???????root?????????????????????
????????mysqladmin????mysql server??????????mysqladmin???????????????mysqladmin????????
?????????mysql???????????mysql?root???
?????
??mysql> Insert INTO mysql.user (Host,User,Password)
??VALUES(‘%’,'jeffrey’,PASSWORD(‘biscuit’));
??mysql> FLUSH PRIVILEGES
????????????????????jeffrey????biscuit???mysql???????????????????PASSWORD?????????FLUSH PRIVILEGES?
?????
??????????????REPLACE??
??mysql> REPLACE INTO mysql.user (Host,User,Password)
??VALUES(‘%’,'jeffrey’,PASSWORD(‘biscuit’));
??mysql> FLUSH PRIVILEGES
?????
????SET PASSWORD??
??mysql> SET PASSWORD FOR jeffrey@”%” = PASSWORD(‘biscuit’);
????????PASSWORD()??????????FLUSH PRIVILEGES?
?????
????GRANT … IDENTIFIED BY??
??mysql> GRANT USAGE ON *.* TO jeffrey@”%” IDENTIFIED BY ‘biscuit’;
????PASSWORD()??????????????FLUSH PRIVILEGES?
?????PASSWORD() [??]??Unix????????????????
??MySQL ?????????
???? MySQL??????????
??killall -TERM mysqld
???? MySQL?
??bin/safe_mysqld –skip-grant-tables &
????????????? MySQL??
??????
??>use mysql
??>update user set password=password(“new_pass”) where user=”root”;
??>flush privileges;
????? MySQL???????? MySQL ?
??Mysql????
??Windows
??1.???????????
??2.??MySQL????
??3.???????????MySQL???????????????c:\mysql???C:\mysql\bin?
??4.????????MySQL
??c:\mysql\bin>mysqld-nt –skip-grant-tables
??5.???????????c:\mysql\bin?????root????
??c:\mysql\bin>mysqladmin -u root flush-privileges password “newpassword”
??c:\mysql\bin>mysqladmin -u root -p shutdown
???newpassword???????root????????????????????????????????
??6.??MySQL Server????????Mysql?
??7????????????Mysql??
??Unix&Linux
??1.?root????mysqld????????
??2???kill?????mysqld????
??3???–skip-grant-tables????MySQL Server
??shell>mysqld_safe –skip-grant-tables &
??4.?root@localhost?????
??shell>mysqladmin -u root flush-privileges password “newpassword”
??5???MySQL Server?
??Mysql????
??Mysql?????Mysql????????
??mysql -u root mysql
??mysql> Update user SET password=PASSWORD(“new password”) Where user=’name’;
??mysql> FLUSH PRIVILEGES;
??mysql> QUIT
???????MySQL????????
????MySQL????????mysql??user??????????Windows 2003??MySQL??user????????????
???c:\mysql\data\mysql\(linux ????/var/lib/mysql/mysql/)??????user?????user.frm?user.MYD?user.MYI
??user.frm //user?????
??user.MYD //user?????
??user.MYI //user?????
???????????????????????????????MySQL????????????????user.MYD????
????
??#. /etc/rc.d/init.d/mysql stop
??#. /etc/rc.d/init.d/mysql start
??#mysql -u root -p XXXXXX
????????Windows 2003?mysql?????
??mysql>use mysql
??mysql>update user set Password=PASSWORD(‘xxxxxx’) where User=’root’;
???????????user???????
??????????????????user.*????????Windows 2003????Windows 2003??ls -l?????666?
???Linux??????????????600(???????600????????????????mysql??????????? root?????????????????????666?????????????????????)?? /var/lib/mysql/mysql/?ls -l????
??#chown -R mysql:mysql user.*
??#chmod 600 user.*
??//OK,DONE
??????MYSQL?????
??mysql>use mysql
??mysql>update user set Password=PASSWORD(‘xxxxxx’) where User=’root’;
??mysql>FLUSH PRIVILEGES;
?????????????windows ?mysql?????????????????
??mysql>delete from user where User=”;
??mysql>delete from user where Host=’%';
??mysql>FLUSH PRIVILEGES;
?????????????????????????????????????????user?????????????
???????(????????????,mysql????????)
??1. ?mysqld server ??kill????mysqld server(?? kill -9)?????ID??????MYSQL???????????
??killall -TERM mysqld
??????UNIX?root??????????SERVER????????????????
??2. ??`–skip-grant-tables’ ????? mysqld? LINUX??
??/usr/bin/safe_mysqld –skip-grant-tables , windows?c:\mysql\bin\mysqld –skip-grant-tables
??3. ????????mysqld server
??>use mysql
??>update user set password=password(“new_pass”) where user=”root”;
??>flush privileges;
??????????
??’mysqladmin -h hostname -u user password ‘new password”
??4. ??????
??’mysqladmin -h hostname flush-privileges’
?????? SQL ??
??’FLUSH PRIVILEGES’
??5.
??killall -TERM mysqld
??6.???????
???????
??????????????user.MYD???
???????????????????????????????????????????????????????????????????????????????????????????????????????????????user????????????????????????????????linux??user??????????????????? ?
?????????Windows????????
??1.???????MySQL?
??2.??DOS?????mysql\bin???
??3.??
??mysqld-nt –skip-grant-tables
?????????????????????
??4.????DOS?????????DOS????????????mysql\bin???
??5.??mysql???????????MySQL??? >
??6. ???????
??>use mysql;
??(>?????????,????????)
??6.????
??> update user set password=password(“123456″) where user=”root”;
??(????????)
??7.???????????
??>flush privileges;
??8.??
??> \q
??9.??????????MySQL??????root?????????123456???
???????????user???????
????MySQL?Windows???Mysql\data\mysql??????user.frm,user.MYD,user.MYI???????MySQL??????????????user?????????????????user.MYD?????
?????????user.MYD???????????UltraEdit?????????MySQL???user.MYD?????root ?????????565491d704013245??????123456???????????????????????????????????? 00 02 02 02 02 02 02 02,????????????????????*????????????MySQL???root???????
????,?????…??????…??????…??????????…????????…????????????…??????…???????????…????????…?????…????????????!??????!??????…????????!????????!?????????????.??????????????….