《Mysql必讀MySQL教程》要點:
本文介紹了Mysql必讀MySQL教程,希望對您有用。如果有疑問,可以聯系我們。
MYSQL必讀Linux操作系統:CentOS 6.3
1、下載:當前mysql版本到了5.6.10
下載地址:http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.11.tar.gz
MYSQL必讀2、安裝必要軟件包
?
MYSQL必讀3、開始編譯安裝(默認情況下是安裝在/usr/local/mysql )
?
MYSQL必讀[root@jbxue ~]# groupadd mysql
[root@jbxue ~]# useradd -r -g mysql mysql
[root@jbxue ~]# tar -zxvf mysql-5.6.10.tar.gz
[root@jbxue ~]# cd mysql-5.6.10
[root@jbxue mysql-5.6.10]# cmake .
[root@jbxue mysql-5.6.10]# make && make install
[root@jbxue ~]# chown -R mysql.mysql /usr/local/mysql
[root@jbxue ~]# cd /usr/local/mysql/scripts
[root@jbxue ~]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[root@jbxue ~]# cd /usr/local/mysql/support-files
[root@jbxue support-files]# cp mysql.server /etc/rc.d/init.d/mysql
[root@jbxue support-files]# cp my-default.cnf /etc/my.cnf
[root@jbxue ~]# chkconfig -add mysql
[root@jbxue ~]# chkconfig mysql on
[root@jbxue ~]# ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
[root@jbxue ~]# ln -s /usr/local/mysql/include/mysql /usr/include/mysql
[root@jbxue ~]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@jbxue ~]# ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump
[root@jbxue ~]# ln -s /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk
[root@jbxue ~]# service mysql start
Starting MySQL SUCCESS!
[root@jbxue ~]# mysqladmin -u root password pwd
[root@jbxue ~]# mysql -uroot -ppwd
Welcome to the MySQL monitor.? Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.6.11 Source distribution
MYSQL必讀Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
MYSQL必讀Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
MYSQL必讀Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
MYSQL必讀4、開啟遠程連接權限
主機環境搭建之常用配置篇-Linux mysql 允許遠程連接
MYSQL必讀通常,要在本地使用一些工具管理我們的數據庫服務器,那么安裝MySQL后,默認是不允許遠程拜訪的,如何配置遠程連接呢?
錯誤:
ERROR 1130: Host ’192.168.1.3′ is not allowed to connect to this MySQL server
MYSQL必讀解決辦法:
?
MYSQL必讀注意:在mysql 命令行形式下必定要輸入”;”.
歡迎參與《Mysql必讀MySQL教程》討論,分享您的想法,維易PHP學院為您提供專業教程。