This article describes the process of installing Mitaka Nova in Ubuntu 16.04 under a single point
Step 1:root identity into MySQL, create two databases
CREATE DATABASE Nova_api;
CREATE DATABASE Nova;
Step 2: Still in the database, create a Nova user
Grant all on * * to ' user1 ' identified by ' passwd 'Grant Select,update,insert on db1.* to ' user2 ' @ ' 192.168.133.1 ' identified by ' passwd ';Grant all on db1.* to ' user3 ' @ '% ' of ' identified by ' passwd ';Show grants;Show grants for
First, download the MySQL compression pack on Oracle's websiteDownload this tar package and upload it to the server via FTP, unzip it to the corresponding path by Xshell, check if the system has MARIADB installed, because it is the branch of MySQL,
Preliminary incremental recovery of MySQL data A. Configuring the MY.CNF configuration fileRename the Log-bin parameter in the MY.CNF configuration file to MYSQLBIN_ZBF first, so that updating a thing in the MySQL database will be updated in this
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
Mysql DatabaseMysql database: Essentially a software for storing and managing filesSo for MySQL, there are two of software:--Server Software:Socket Service SideLocal file operations--Client software:Socket ClientSend instructionsParsing instructions
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
One, MySQL user managementMySQL > Grant all on.To ' user1 ' @ ' 127.0.0.1 ' identified by ' 123456 '; Authorize all permissions to User1 users;.The first onerefers to a library name, such as MySQL.The specified source IP is either 127.0.0.1,@ or
Purpose of the backup Data loss scenarios such as disaster recovery, hardware failure, software failure, natural disaster, hacker attacks, misoperation testing, etc.Backup Note points Can tolerate the maximum amount of data lostHow long does it
Clear screen: CLS
MySQL Basics
Start MySQL net start MySQL
Shut down MySQL net stop MySQL
Login Mysql-uroot-p
Exit mysql>exit;
mysql>quit;
mysql>\p;
Displays the current server version of SELECT version ();
Show Current Time SELECT now
Operating system is CENTOS7 641, modify the/ETC/MY.CNF, add a line under the [mysqld] subsection: Skip-grant-tables=1This line of configuration allows mysqld to be not validated at startup2. Restart MYSQLD service: systemctl restart Mysqld3. Log in
SQL: Called Structured Query Language, it is internally divided into: DML statements: Data manipulation language, for increment (insert), delete (delete), check (select), Change (update) DDL statement: Data definition language for data storage,
1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to
Operating system is CENTOS7 641, modify the/ETC/MY.CNF, add a line under the [mysqld] subsection: Skip-grant-tables=1This line of configuration allows mysqld to be not validated at startup2. Restart MYSQLD service: systemctl restart Mysqld3. Log in
Unzip MySQL to D packing directory
Copy the My-default.ini under the decompression path and modify the name to My.ini
The contents of the My.ini are as follows
[Client]Default-character-set=utf8 [mysqld]
Now finally I found the solution, as follows (please test method three, thank you!) ): Method One: #/etc/init.d/mysql Stop # mysqld_safe--user=mysql--skip-grant-tables--skip-networking & # Mysql-u root MySQL mysql> UPDATE user SET
How to install MySQL 5.7.22 in the Redhat 7.0 systemToday to introduce you how to install mysql5.7, before the installation, the first thing to see is that your system has been installed in the case. Type Rpm-qa|grep MySQL, if nothing appears,
1.MySQL Engine Overview 1.1 What is a storage engineWhen we record a video file, it can be converted to different formats such as mp4,avi,wmv, and on the computer's disk will also exist in different types of file system Windows common Ntfs,fat32,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.