ubuntu mysql 5.6 安装与双机热备 问题及解决方法汇总 1.安装脚本: #!/bin/sh echo "安装前请确保mysql已被删除" sudo rm -r /opt/mysql sudo rm /etc/my.cnf sudo groupadd mysql sudo useradd -r -g mysql mysql #wget http://cdn.mysql.com/Downloads/MyS
ubuntu mysql 5.6 安装与双机热备 问题及解决方法汇总1.安装脚本:
#!/bin/sh
echo "安装前请确保mysql已被删除"
sudo rm -r /opt/mysql
sudo rm /etc/my.cnf
sudo groupadd mysql
sudo useradd -r -g mysql mysql
#wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
tar -zxvf mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
sudo mv mysql-5.6.13-linux-glibc2.5-x86_64 /opt/mysql
sudo ln -s /opt/mysql /usr/local/mysql
#初始化数据库
sudo /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
sudo chown -R mysql:mysql /opt/mysql #添加权限;
#启动shell放到系统服务
sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
#配置文件放至全局
sudo cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
#修改data目录权限
#cd /opt/mysql
#sudo chmod -R 755 data
echo "----ok----"
2.mysql 配置与用户权限管理
(1)启动mysql
sudo /etc/init.d/mysql start
(2)登录
初次登录 不需要密码 ./mysql/bin/mysql -u root
(3)设置密码
update mysql.user set password=password('root') where user='root';
grant privileges;
下次登录时就需要 密码
./mysql/bin/mysql -u root -p
(4)设置访问权限/资源限制
GRANT ALL ON *.* to root@'175.102.99.%' IDENTIFIED BY 'passwd';
GRANT ALL ON *.* to user@'172.16.8.%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;
官方参考:http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#request-access
(5)mysql 重启
sudo /etc/init.d/mysql restart
期间问题小计:
三种启动方式:
mysqld '在bin目录下'
[mysqld], [server], [mysqld-major-version]
mysql.server'在support-files目录下'
'如果你使用Linux 服务器RPM软件包(MySQL-server-VERSION.rpm),mysql.server脚本将安装到/etc/init.d目录下,'
[mysqld], [mysql.server], [server]
mysqld_safe '在bin目录下'
'使用mysqld_safe而不使用mysqld的好处是mysqld_safe“守护”其mysqld进程,如果用kill –9发送的信号或由于其它原因(例如分段故障)进程终止,则重启进程。'
[mysqld], [server], [mysqld_safe]
mysql 资料:http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html
ubuntu 下手动安装mysql 详细版:http://www.cnblogs.com/wuhou/archive/2008/09/28/1301071.html











SET PASSWORD FOR ''@'localhost' = PASSWORD('rundong');
'第一次未设置密码时,不用 -p ,更新密码后,-p 会提示输入密码,必须密码登录/bin/mysql -h -u -p'
update mysql.user set password=password('rundong') where user='root'; ok
A.4.1. 如何复位根用户密码
http://dev.mysql.com/doc/refman/5.1/zh/problems.html#resetting-permissions












#ok配置文件: /etc my.cnf 日志路径;/var/log/mysql/mysqld.log 启动路径:/etc/init.d/mysql 安装路径:/opt/mysql/bin 软连接:/usr/local/mysql
备份脚本:
#!/bin/sh
dir_name=/opt/mysql/dump/rundong_$(date +%Y%m%d)
[ -d /opt/mysql/dump ] || mkdir /opt/mysql/dump
[ -d ${dir_name} ] || mkdir ${dir_name}
#mysqldump-- --opt 该选项是速记;它可以给出很快的转储操作并产生一个可以很快装入MySQL服务器的转储文件
#于备份一个整个的数据库:
/opt/mysql/bin/mysqldump --opt -d -uroot -ppasswd databse > ${dir_name}.sql
#sudo chown -R mysql:mysql /opt/mysql #添加权限;
/opt/mysql/bin/mysqldump --opt --tab ${dir_name} -udump -ppasswd database

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

The steps to build a MySQL database include: 1. Create a database and table, 2. Insert data, and 3. Conduct queries. First, use the CREATEDATABASE and CREATETABLE statements to create the database and table, then use the INSERTINTO statement to insert the data, and finally use the SELECT statement to query the data.

MySQL is suitable for beginners because it is easy to use and powerful. 1.MySQL is a relational database, and uses SQL for CRUD operations. 2. It is simple to install and requires the root user password to be configured. 3. Use INSERT, UPDATE, DELETE, and SELECT to perform data operations. 4. ORDERBY, WHERE and JOIN can be used for complex queries. 5. Debugging requires checking the syntax and use EXPLAIN to analyze the query. 6. Optimization suggestions include using indexes, choosing the right data type and good programming habits.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

SublimeText3 Linux new version
SublimeText3 Linux latest version

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

Notepad++7.3.1
Easy-to-use and free code editor