涂抹mysql笔记-管理mysql服务

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了涂抹mysql笔记-管理mysql服务，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3442字，纯文字阅读大概需要5分钟。

内容图文

support-files/mysql.server脚本启动mysql不推荐，推荐使用mysqld_safe启动：
$ mysqld_safe --defaults-file=/mysql/conf/my.cnf &
netstat -lnt |grep 3306
ps -ef |grep mysql 查看mysql端口和进程

配置mysql
mysql5.6默认root用户不设密码的直接敲入mysql登录。
增强安全性：
select user,host from mysql.user;
+------+-----------+
| user | host |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| | linux01 |
| root | linux01 |
| | localhost |
| root | localhost |
+------+-----------+
6 rows in set (0.01 sec)
6个用户，两个用户没有用户名。所以直接可通过mysql登录。
下面保留一条root用户其他用户全部删除。
修改root用户名
update mysql.user set user=‘system‘,password=password(‘oralinux‘);
(root@localhost) [(none)]>select * from mysql.db \G
truncate table mysql.db;

root@localhost) [(none)]>exit
Bye
[mysql@linux01 mysql]$ mysql
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)
[mysql@linux01 mysql]$ mysql -uroot -p‘oralinux‘
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
[mysql@linux01 mysql]$ mysql -usystem -p‘oralinux‘
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.34-log JASON

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

(system@localhost) [(none)]>

创建管理脚本，创建中间定义文件，目的是提高脚本的复用性：
vi /mysql/scripts/mysql_env.ini
#set env
MYSQL_USER=system
MYSQL_PASS=‘oralinux‘

#check parameter
if [ $# -ne 1 ]
then
HOST_PORT=3306
else
HOST_PORT=$1
fi
$ chmod 600 /mysql/scripts/mysql_env.ini
创建mysql_db_startup.sh脚本，用于启动mysql服务：
#!/bin/sh
# Created by jason
source /mysql/scripts/mysql_env.ini
echo "Startup MySQL Service:localhost_"${HOST_PORT}
/mysql/bin/mysqld_safe --defaults-file=/mysql/conf/my.cnf &

$ vi /mysql/scripts/mysql_db_shutdown.sh
#!/bin/sh
#Created by jason
source /mysql/scripts/mysql_env.ini
echo "Shutdown MySQL Service:localhost_"${HOST_PORT}
/mysql/bin/mysqladmin -u${MYSQL_USER} -p${MYSQL_PASS} -S /mysql/conf/mysql.sock shutdown
创建sqlplus.sh脚本用于快速登录：
$vi /mysql/scripts/sqlplus.sh
#!/bin/sh
#Created by jason
source /mysql/scripts/mysql_env.ini
echo "Login MySQL Service:localhost_"${HOST_PORT}
/mysql/bin/mysql -u${MYSQL_USER} -p${MYSQL_PASS} -S /mysql/conf/mysql.sock $2
chmod +x /mysql/scripts/sqlplus.sh
编辑mysql用户变量，将上述路径加入到PATH中
echo "export PATH=/mysql/scripts:\$PATH" >> ~/.bash_profile
source ~/.bash_profile
设置开机启动：root下
# vi /etc/rc.localhost
# autostart mysql ,added by jason at 2017-03-31
sudo -i -u mysql /mysql/scripts/mysql_db_startup.sh 3306 > /mysql/logs/mysql_db_startup.log 2>&1
执行sudo命令遇到下列错误：
sudo:sorry,you must have a tty to run sudo
vi /etc/sudoers 注释掉56行
#Defaults requiretty

涂抹mysql笔记-管理mysql服务

标签：efault   group   变量   max   profile   通过   chmod   mysqld   ase   

本文系统来源：http://www.cnblogs.com/datalife/p/6688328.html

内容总结

以上是互联网集市为您收集整理的涂抹mysql笔记-管理mysql服务全部内容，希望文章能够帮你解决涂抹mysql笔记-管理mysql服务所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端