Install MySQL manually on ubuntu12.04

1, download the MySQL tar package from the network, I downloaded the version of 5.6, as follows: mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

2, upload to Ubuntu, directly copy or use the tool can be, in my user imx under the download.

3, copy the mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz to/usr/local, use the command

#tar-XZVF mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

4. Rename the extracted folder: sudo mv mysql-5.6.26-linux-glibc2.5-x86_64 MySQL

5. Modify MySQL owner and genus as MySQL user

#sudo chown-r mysql:mysql MySQL

6, install the dependent package, if not installed, otherwise in the installation of error

sudo apt-get install Libaio-dev

7. Execute MySQL Installation script

sudo scripts/mysql_install_db--user=mysql

8. Copy the MySQL configuration file to the ETC directory (global configuration)

Note: The default profile name for version 5.6 is changed by the original My-medium in order to My-default.

sudo cp support-files/my-default.cnf/etc/my.cnf

The parameters of MySQL are configured in this configuration file, if not modified, the default parameters are used.

9. Start MySQL

sudo bin/mysqld_safe--user=mysql &

This command is the daemon that initiates mysqld, which is mysqld

10. Configure MySQL client, MySQL client MySQL shell,

sudo cp support-files/mysql.server/etc/init.d/mysql.server

You can also modify MySQL,

11. Add the Mysql/bin/mysql command to the user command, or add the Mysql/bin directory to the path

To join the user command:

sudo ln-s/usr/local/mysql/bin/mysql/usr/local/bin/mysql

Add Environment variables:

Export path= $PATH:/usr/local/mysql/bin

12. View MySQL Running status

sudo service mysql.server status
If it works, MySQL running will be displayed.

If not running is displayed, the service should not be started earlier, and can be started directly with service Mysql.server start

sudo service mysql.server [status|start|stop]

13. Let MySQL boot [defaults], cancel boot [remove]

sudo update-rc.d-f mysql.server defaults [remove]

14. Initialize the MySQL root user password

sudo bin/mysqladmin-u root password ' cipher text '

15. View the MySQL process:

#ps-a|grep MySQL
Show similar:
1829? 00:00:00 Mysqld_safe
1876? 00:00:31 mysqld
2. #kill-9 1829
3. #kill-9 1876

Ps-ef |grep MySQL

16. Allow root users to log in remotely

1> into Mysql:mysql–u root–p

2> Change database: use MySQL;

3> login from any host: Grant all privileges on * * to [email protected] '% ' identified by ' cipher text ' with GRANT option;

4> login from specified host: Grant all privileges on * * to [email protected] ' 192.168.1.101 ' identified by ' passw0rd ' with GRANT option;

5> authorization entry into force: flush privileges;

6> See if the host is added for% authorization: SELECT * from user;

7> View Database Character set: Show variables like ' character% ';

After we start MySQL, we can then test it and use the "MySQL" command to access the MySQL database console.
$mysql-U Root

Here the reason for using-u root is because I am now a general user (imx6), if you do not add-u root, MySQL will assume that it is imx6 log in. Note that I do not have access to root user mode here because it is not necessary. In general, the database in MySQL operation, there is no need to enter the root user mode, only in the setting of this possibility.

After entering MySQL, the most important thing is to set up the root user password in MySQL, otherwise, the MySQL service is not safe to say.
Mysql> GRANT All privileges on * * to [e-mail protected] identified by "123456";
If you need to use root for remote access from other machines, you can use
Mysql> GRANT All privileges on * * to [e-mail protected] "%" identified by "123456";
Note that I use 123456 as the root user's password, but the password is not secure, please use a combination of uppercase and lowercase letters and numbers, and not less than 8 bits.

Configuration file Reference:

[HTML]View PlainCopy 

2. # for advice The change settings
4. # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
6. # * * * Don't EDIT this FILE. It ' s a template which'll be copied to the
8. # * * * default location during install, and would be replaced if you
10. # * * * * Upgrade to a newer version of MySQL.
14. [Client]
16. Port = 3306
18. default-character-set=UTF8
20. # Here's entries for some specific programs
22. # The following values assume you has at least 32M RAM
26. [Mysqld]
28. character_set_server=UTF8
30. lower_case_table_names=1
32. init_connect=' SET NAMES UTF8 '
36. lower_case_table_names=1
40. max_connections=
42. Max_allowed_packet = 32M
46. Thread_cache_size =
48. Thread_concurrency = 8
52. Query_cache_size = 128M
56. # Remove Leading # and set to the amount of RAM for the most important data
58. # Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.
60. # innodb_buffer_pool_size = 128M
64. # Remove Leading # to turn on a very important data integrity option:logging
66. # Changes to the binary log between backups.
68. # Log_bin
72. # These is commonly set, remove the # and set as required.
74. # Basedir = ...
76. # DataDir = ...
78. # port = ... ..
80. # server_id = ...
82. # socket = ... ..
86. # Remove Leading # To set options mainly useful for reporting servers.
88. # The server defaults is faster for transactions and fast selects.
90. # Adjust sizes as needed, experiment to find the optimal values.
92. join_buffer_size = 16M
94. sort_buffer_size = 16M
96. # read_rnd_buffer_size = 2M
100. Sql_mode=no_engine_substitution,strict_trans_tables
104. [Mysqldump]
106. Quick
108. Quote-names
110. Max_allowed_packet = 32M
114. [MySQL]
116. No-auto-rehash

Install MySQL manually on ubuntu12.04