Centos??Mysql?????y??
???????????? ???????[ 2016/3/1 11:14:09 ] ????????MySQL ?????
????1. ???yum???mysql
????// ??????update???
????sudo yum update
????// ???????mysql???????汾
????yum list | grep mysql
????// ??????~
????yum install -y mysql-server mysql mysql-deve
????2. ???????mysql????
????// ???
????service mysqld start
????// ????
????service mysqld restart
????// ???
????service mysqld stop
????3. mysql????????
????// ????????
????/usr/bin/mysqladmin -u root password '??????'
????4. mysql?????????
????// ????????????????
????chkconfig --list | grep mysqld
????// ??е????????????
????chkconfig mysqld on
????5. ?????????/etc/my.cnf
????6. mysql??????(???????????????mysql????????????)
????// ????utf-8????
????set character_set_client=utf8;
????set character_set_connection=utf8;
????set character_set_database=utf8;
????set character_set_results=utf8;
????set character_set_server=utf8;
????// ??????
????show variables like 'character_set_%';
????show variables like 'collation_%';
????7.mysql??????????
????// ????????????????????????????????*??????????????
????// ????????????????????????????*?????????????е??????
????// ????????????????????????
????// IP????????????ip????????%???????ip
????// ?????????????????????????
????grant all PRIVILEGES on ???????.???? to ?????@'IP???' identified by '????';
????// ???????root????????ip????????????????
????grant all PRIVILEGES on *.* to root@'%' identified by '????';
??????
???·???
??????????????????
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