root账户登录的。错误代码在下面,求指点下。
Starting MySQL./usr/local/mysql/bin/mysqld_safe: line 586: /var/lib/mysql/mysqld_safe.pid: No such file or directory
awk: (FILENAME=- FNR=1) warning: error writing standard output (Broken pipe)
2017-04-22T02:51:57.520636Z mysqld_safe error: log-error set to '/var/log/mariadb/mariadb.log', however file don't exists. Create writable for user 'mysql'.
错误是从 初始化mysql数据库时就开始了
# /usr/local/mysql/bin/mysqld --initialize-insecure --datadir=/usr/local/mysql/data/ --user=mysql
错误提示如下
2017-04-22T12:45:43.505209Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
谢谢哥哥姐姐给看下
centos 7.2 安装mysql 运行到:/etc/init.d/mysqld start 启动MySQL数据库是设置错误造成的,解决方法为:
1、先启动Mysql服务,service mysqld start。
2、尝试连接数据库。输入mysql,然后 \q 关闭连接。
3、开启3306端口并保存。
4、连接mysql数据库。设置密码。
5、设置Mysql远程访问账户密码就可以了。