Ubuntu Linux: MySQL installation and basic MYSQL operations

Install MySQL

Sudo apt-Get install mysql-Server

This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below.

Configure MySQL

Note: In ubuntu, MySQL only allows local access by default. If you want access from other machines, you need to change the/etc/MySQL/My. CNF configuration file! Next we will step by step:

After the default MySQL installation, the root user does not have a password. Therefore, use the root user to enter:

$ Mysql-u Root

-U root is used here because I am a general user (firehare). If-u root is not added, MySQL will assume that it is a firehare logon. Note: I have not entered the root user mode here because it is unnecessary. In general, it is not necessary to enter the root user mode to operate the database in MySQL. This is only possible when the database is set.

After entering MySQL, the most important thing is to set the root user password in MySQL. Otherwise, the MySQL service is no longer secure.

Mysql> grant all privileges on *. * to root @ localhost identified by "123456 ";

Note: I use 123456 as the root user password, but this password is not safe. Please use a password with a mix of uppercase and lowercase letters and numbers, and at least 8 characters.

In this case, the root user password in MySQL is set up, and then the database you need is created with the root user. Here we take xoops as an example:

Mysql> Create Database xoops;

Mysql> grant all privileges on xoops. * To xoops_root @ localhost identified by "654321 ";

In this way, a xoops_roots user is created, which has all permissions on the database xoops. In the future, we will use xoops_root to manage the xoops database, instead of using the root user. This user's permissions will only be limited to the xoops database.

If you want to implement remote access or control, you have to do two things:

1:

Mysql> grant all privileges on xoops. * To xoops_root @ "%" identified by "654321 ";

Allows the xoops_root user to log on to MySQL from any machine.

Second:

$ Sudo gedit/etc/MySQL/My. CNF

Earlier versions

> Skip-networking => # Skip-networking

New Version

> Bind-address = 127.0.0.1 => # bind-address = IP address of your machine

This allows other machines to access MySQL.

Basic MYSQL operations (cainiao level)

1. Connect to the MySQL database:
Format: mysql-H host address-u user name-P User Password
For example, connecting to a local MySQL Server
Mysql-u root-P press enter, and a prompt box appears, asking you to enter the password
Connect to a remote MySQL Server
Mysql-h10.1.17.73-uroot-plogin
2. Exit MYSQL:
Command: Exit
3. mysql password,
(Note: the root user of the mysql database that has just been installed does not have a password .)
Format: mysqladmin-u username-p old password New password
For example, add a password to the root user (when installation is complete)
Mysqladmin-uroot-password login
Change root Password
Mysqladmin-uroot-plogin password welcome
4. The following are some of the most common database operation commands:
Show databases // display the Database Name
Show tables; // SHOW TABLE
Use databases_name; show tables; // display the table structure in the database
Describe table_name; // display the data table structure
Create database database_name; // create a database
Use database_name; create table table_name (Field List); // create a table
Drop database database_name; // delete a database
Drop table table_name; // delete a table
Delete from table_name; // clear the table
5. convert text data to the database
(Note: Text data fields are separated by tabs, and null values are replaced by n .)
Data Loading command:
Load data local infile "filename" into table table_name