Some issues with php mysql install
来源:互联网 发布:大数据的商业价值 编辑:程序博客网 时间:2024/06/06 15:50
缺少包:
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;
- Some issues with php mysql install
- Some serious issues with the new -O option
- Solving install issues with Python 2.7.10 on Windows
- iOS app lifecycle some issues
- [转]some issues about push
- Android. Handling some SQLite issues
- Apche PHP Mysql Install
- How to install Nginx, PHP, PHP-FPM and MySQL under Windows with Cygwin
- Configuring Java (J9) on a Pocket PC with RMI and SWT using CDC Personal Profile: some experiences and issues
- Configuring Java (J9) on a Pocket PC with RMI and SWT using CDC Personal Profile: some experiences and issues
- Known issues with RTP
- Install Apache, PHP, APC, & MySQL on Amazon EC2 with Amazon Linux AMI
- WebLogic Install, Config & start Issues
- ubuntu install apache+php+mysql
- centos install nginx mysql php
- centos install (PHP+Mysql+apache)
- iOS: Some issues about push notification
- ios: Some issues about push notification
- CVS打标签
- 面试技巧(2) 个人面试注意事项
- Mysql 相关网址推荐
- js实现的下拉菜单的左右移动
- 模拟某些网站的开关灯案例
- Some issues with php mysql install
- ECMBoss企业内容解决方案项目系列之(四)架构师如何决定系统的架构
- 无语
- SQL Server学习系列——准备工作
- 未接来电,屏幕一直亮,不关屏怎么办?
- javascript静态页面间的传值和接收
- strut2 实现国际化
- asp.net url带中文参数显示乱码的问题
- 网球比赛