Document directory
Article 1: install and configure MySQL
Note: To install MySQL using yum in centos Linux, you must install MySql in a network environment. For more information about how to connect to the network in Linux, see the previous
Bugzilla install redbooks on WindowsIt is really difficult to install Bugzilla in a Windows environment. The appconfig and template modules are hard to find and cannot find the Win32 version. This step is worse than the success.I finally found an
Core tips: This article summarizes the mysql-noinstall version, that is, the installation and configuration application of the decompressed version. These operations are commonly used. The article does not describe the executable installation
Server restart
When mysqld is started, all authorization table content is read into the memory and takes effect from that time.
Immediately applied by the server
Modifications made to the authorization table using Grant, revoke, or set password will
Common MySQL database operations
1. Start the MySQL databaseIn the above command window, enter the command: Net start mysql5In this way, the MySQL service is started.
2. (local) log on to the MySQL databaseIn the preceding command window, run
Installation and configuration of green MySQL
I downloaded MySQL 5.1.
:
Http://dev.mysql.com/downloads/mysql/
Download the free installation package (mysql-noinstall-5.1.45-win32.zip)
Decompress the compressed file to E: \ mysql-5.1.39-win32
Summary of installing and configuring the application in mysql5 decompressed windows
Note: This article summarizes the mysql-noinstall version, that is, the installation and configuration application of the decompressed version. These operations
EnterSudo taskselThen a software package interface will appear, move the cursor to the lamp server, press the space, and then select this item. Other items can be deselected, and click OK.Next, you will be asked to enter the password of the root
After installing MySQL, configure the environment variables and then
Input MySQL
Go to MySQL
Then you can
Use MySQL;
Select * from user;
To view all users;
Execute the script file in MySQL:
Mysql> source XXX. SQL;
1.1 add users in two ways: (convert)
To start the mysqld server from the command line, you should start the console window (or "DOS window") and enter the command:
C:/> C:/program files/MySQL Server 5.0/bin/mysqld
The path used in the preceding example varies depending on the MySQL
Install MySQL 5.6.23 and ubuntu5.6.23 in UbuntuInstall MySQL 5.6.23 in Ubuntu1. download the source code package for Linux-generic, decompress it, rename the decompressed folder to mysql, and move it to the/usr/local directory; tar-xzf
To Test Database Synchronization on the goldengate heterogeneous platform, you need to test data synchronization between MYSQL and Oracle. Therefore, this article introduces the process of installing MYSQL with source code.
The installation process
1) download the Linux-Generic package of Mysql5.5: http://download.softagency.net/mysql/downloads/mysql-5.5/ I download the license mysql-5.5.17-linux2.6-x86_64.tar.gz.2) Confirm that the installed mysql has been thoroughly uninstalled. For details,
MariaDB is installed on CentOS 6.5 By chszs, which must be noted in the reprint. Blog homepage: http://blog.csdn.net/chszs1. software environment: CentOS 6.5x64MariaDB 5.5.362. Installation Process 1) Create the MariaDB. repo file in the/etc/yum.
The first time I came into contact with the Server version of Linux: Ubuntu Server 12.04, it was also the first time I installed binary mysql with command lines. It took two days and one night to get started. Leave for memo!
First download the
After the database server is set up, the first thing we need to do is not to consider which MySQL-initiated programs should be run on the server that supports the database, but when the database is damaged, how to safely restore to the last normal
Change Password:1. For example, if your root user does not have a password and you want to change the password to 123456, the command is:Mysqladmin-u root password 1234562. If your root account has a password (123456), the command to change the
MySQL Study -- Mysql startup failure "mysql. host", -- mysqlmysql. hostMySQL Study-Mysql startup failure "mysql. host"
System Environment:
Operating System: RedHat EL55
DB Soft: Mysql 5.6.4-m7
After mysql is installed through the source code
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.