ubuntu 16 setup mariadb 10.0(a.k.a.mysql) log-error
来源:互联网 发布:淘宝聚便宜 编辑:程序博客网 时间:2024/06/10 04:02
OS: ubuntu16.04
mariadb 其实就是mysql, 只不过mysql被oracle收购,为防止oracle闭源,所以mysql社区外延出了mariadb。
之前一直修改my.cnf,但没什么效果,后来改动mariadb.cnf,成功指定log-error路径文件
安装
DEBIAN_FRONTEND=noninteractive + -y : 无交互安装
- apt-get update && DEBIAN_FRONTEND=noninteractive apt-get install -y -V –no-install-recommends mariadb-server
文件路径
- mysql dir: /etc/mysql/
- data dir: /var/lib/mysql
- log dir: /var/log/mysql
设置error log
mariadb.cnf 是my.cnf的最终link结果, 所以我们直接修改mariadb.cnf
- /etc/mysql/my.cnf -> /etc/alternatives/my.cnf-> /etc/mysql/mariadb.cnf
mariadb.cnf
default
# The MariaDB configuration file## The MariaDB/MySQL tools read configuration files in the following order:# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,# 2. "/etc/mysql/conf.d/*.cnf" to set global options.# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.# 4. "~/.my.cnf" to set user-specific options.## If the same option is defined multiple times, the last one will apply.## One can use all long options that the program supports.# Run program with --help to get a list of available options and with# --print-defaults to see which it would actually understand and use.## This group is read both both by the client and the server# use it for options that affect everything#[client-server]# Import all .cnf files from configuration directory!includedir /etc/mysql/conf.d/!includedir /etc/mysql/mariadb.conf.d/
add code
[mysqld_safe]log_error=/var/log/mysql/mysql_error.log[mysqld]log_error=/var/log/mysql/mysql_error.log
http://www.pontikis.net/blog/how-and-when-to-enable-mysql-logs
阅读全文
0 0
- ubuntu 16 setup mariadb 10.0(a.k.a.mysql) log-error
- Setup Error the setup controller has encountered a problem during install. Please review the log fil
- SetUp A Mysql Datasource
- How to setup a Ubuntu Server?
- mariadb setup
- Setup a Subversion server
- setup a subversion server
- mysql(mariadb) error 1698(28000)
- the setup controller has encountered a problem during install.Please review the log files for furthe
- How To Setup a CA
- setup中设置8259A
- Linux - setup a tftp server
- How to Setup A Database
- Ubuntu 16 按住Mariadb
- Mysql Error log
- Setup Was Unable to Create a DCOM User Account" Error Message in Visual Studio 6.0
- Node.js Setup:This may indicate a problem with this package. The error code is 2503.
- log 080821a
- Loadrunner Http Json接口压力测试
- _access的用法(判断文件夹是否存在)
- 图片居中,多余隐藏
- 车厢调度
- African lions face same threats as extinct Ice Age ancestors
- ubuntu 16 setup mariadb 10.0(a.k.a.mysql) log-error
- Android中如何实现将具有相同特征的id循环获得
- callee和caller的作用与区别
- Linux下安装Nginx服务器
- 解决AJAX在火狐,谷歌都能正常运行,而IE不行的问题
- 方法重写
- 负边距的应用
- windows下面部署MySQL Cluster7.4/7.5
- 钓鱼网站规则提取工作的python代码重写总结