MySQL????????????????????????
???????????? ???????[ 2014/3/27 9:25:02 ] ????????MySQL ?????
????MySQL??????????????????????????????
????????????????????в??????(???????????????)???????????????????
????????????????????б????????????????????????????
???????????????????????????????л????????????
???????????????????????о???????????????.
????+ ?????????????
????my.cnf??????? /etc/my.cnf
????mysql?????λ?? datadir=/var/lib/mysql
???????????192.168.2.119
???????????192.168.2.220
????????????RHEL5.x 32λ
??????????????: ?????
????+ mysql5.0.77 ???:
?????? ???ú?linux??yum????????yum -y install mysql????
???????????phpmysql??????????yum -y install httpd php mysql mysql-server php-mysql
?????? ???MySQL
????service mysqld start(restart|stop)
???????????????
????1?????????my.cnf???????????????????id??logbin??#?????????廷????????????????????huge.cnf??
????[root@localhost etc]#vi /etc/my.cnf
????# ?????????????????[mysqld]???棬???????????????????????????????????????
[mysqld]
log-bin=mysql-bin
server-id=1
binlog-ignore-db=information_schema
binlog-ignore-db=cluster
binlog-ignore-db=mysql
????2???????????Ч
????[root@localhost etc]service mysqld restart
????3?????????
????[root@localhost etc]mysql -u root -p
????4???????????????????????????????????
????mysql> grant all privileges on *.* to '?????'@'%' identified by '????';
????5????鴴???????
????select user??host from mysql.user;
????6?????????
????mysql> flush tables with read lock;
??????
???·???
??????????????????
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