#----------检查系统中是否已经安装了mysql------------------------------------------------------------------------------------------------------------------------------------------------
sudo netstat -tap | grep mysql
#----------安装mysql,保证联网状态---------------------------------------------------------------------------------------------------------------------------------------------------------
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install mysql-libmysqlclient-dev
#----------查看mysql版本---------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql --version
#----------登录mysql---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql -u root -p //登录到本地服务器
mysql -u username -p -h 服务器ip -P 端口号 //登录到远程服务器
设置远程访问(正常情况下,mysql占用的3306端口只是在IP 127.0.0.1(本地)上监听,拒绝了其他IP的访问(通过netstat可以查看到)。取消本地监听需要修改my.cnf文件):
sudo vi /etc/mysql/my.cnf
bind-address = 127.0.0.1 //找到此内容并注释
#----------启动、停止和查看mysql服务-------------------------------------------------------------------------------------------------------------------------------------------------------
sudo service mysql start
sudo service mysql stop
sudo service mysql status
sudo service mysql restart
#---------mysql安装后的目录结构-------------------------------------------------------------------------------------------------------------------------------------------------------------
服务器的配置文件:/etc/mysql/my.cnf
数据库存放目录:/var/lib/mysql/
相关配置文件存放目录:/usr/share/mysql
相关命令存放目录:/usr/bin(mysqladmin mysqldump 等命令)
启动脚步存放目录:/etc/rc.d/init.d
#--------设置字符编码为utf-8-------------------------------------------------------------------------------------------------------------------------------------------------------------------
sudo gedit /etc/mysql/my.cnf
#在[client]标签下,增加客户端的字符编码
[client]
default-character-set=utf8
#在[mysqld]标签下,增加服务器端的字符编码
[mysqld]
character-set-server=utf8
collation-server=utf8_general-ci
修改之后重启mysql服务,再登录到本地
#---------查看mysql字符集:----------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.02 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.02 sec)
#--------检查mysql服务器占用端口3306--------------------------------------------------------------------------------------------------------------------------------------------------
netstat -nlt | grep 3306