??MYSQL??????????????????????
???????????? ???????[ 2013/9/4 10:03:38 ] ????????
????1.????????
//???MYSQL
@>mysql -u root -p
@>????
//???????
mysql> insert into mysql.user(Host??User??Password) values("localhost"??"phplamp"??password("1234"));
//?????????
mysql>flush privileges;
??????????????????phplamp ???????1234 ???????
?????????
mysql>exit;
@>mysql -u phplamp -p
@>????????
mysql>??????
????2.?????????
//???MYSQL????ROOT??????????????ROOT?????.
@>mysql -u root -p
@>????
//????????????????????(phplampDB)
mysql>create database phplampDB;
//???phplamp??????phplamp??????????????
>grant all privileges on phplampDB.* to phplamp@localhost identified by '1234';
//?????????
mysql>flush privileges;
mysql>????????
/*
????????????????????????????????д:
mysql>grant select??update on phplampDB.* to phplamp@localhost identified by '1234';
//??????????
mysql>flush privileges;
*/
????3.????????
@>mysql -u root -p
@>????
mysql>DELETE FROM user WHERE User="phplamp" and Host="localhost";
mysql>flush privileges;
//?????????????
mysql>drop database phplampDB;
4.?????????????
@>mysql -u root -p
@>????
mysql>update mysql.user set password=password('??????') where User="phplamp" and Host="localhost";
mysql>flush privileges;
mysql> desc mysql.user;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11