缺少包:
php-gd
php-xml
php-mysql
$ yum install php-soap
Mysql:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
如果你想允许用户myuser从ip为192.168.1.3的主机连接到mysql服务器,并使用mypassword作为密码 GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysqladmin -u root -p ab12 password djg345
3、命令行修改root密码:
mysql> UPDATE mysql.user SET password=PASSWORD(’新密码’) WHERE User=’root’;
mysql> FLUSH PRIVILEGES;
4、显示当前的user:
mysql> SELECT USER();
binlog_format:
修改my.cnf:
#binlog_format=mixed
錯誤:
- ERROR Log: binary logging not possible. message: transaction level 'read-committed' in innodb is not safe for binlog mode 'statement'
原因: 當 binlog_format 為 statement 時, read committed 會發生錯誤!!!
解決: (推薦方法4)
- 方法1.mysql> set session transaction isolation level REPEATABLE READ ; REPEATABLE READ ;
- 方法2. mysql> set session binlog_format=row;
- 方法3. mysql> set session binlog_format= mixed;
- 方法4. my.cnf 增加底下兩行,再 restart MySQL
- binlog_format=mixed [OR] row
- innodb_locks_unsafe_for_binlog=1
mysql> SET GLOBAL sort_buffer_size=value;
mysql> SET @@global.sort_buffer_size=value;
要想设置一个SESSION变量的值,使用下面的语法:
mysql> SET SESSION sort_buffer_size=value;
mysql> SET @@session.sort_buffer_size=value;
mysql> SET sort_buffer_size=value;
LOCAL是SESSION的同义词。
如果设置变量时不指定GLOBAL、SESSION或者LOCAL,默认使用SESSION。
要想检索一个GLOBAL变量的值,使用下面的语法:
mysql> SELECT @@global.sort_buffer_size;
mysql> SHOW GLOBAL VARIABLES like 'sort_buffer_size';
要想检索一个SESSION变量的值,使用下面的语法:
mysql> SELECT @@sort_buffer_size;