9159金沙游艺场-奥门金沙游艺场-[欢迎您]

9159金沙游艺场为您呈现最新的面貌!,目前注册送体验金,欢迎您将成为影视娱乐行业新的风向标,是亚洲的优质娱乐先锋。

28安装配备情势图像和文字化教育程

日期:2020-04-14编辑作者:服务器

mysql5.6.28安装配备情势

1.种类基本消息查阅,尝试yum安装

$ sudo -s# df -lhFilesystem Size Used Avail Use% Mounted on/dev/vda1 79G 1.6G 74G 3% /udev 3.9G 8.0K 3.9G 1% /devtmpfs 799M 252K 799M 1% /runnone 5.0M 0 5.0M 0% /run/locknone 3.9G 0 3.9G 0% /run/shm# uname -aLinux nj01 3.16.0-34-generic #47~14.04.1-Ubuntu SMP Fri Apr 10 17:49:16 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux# rpm -qa|grep yumThe program 'rpm' is currently not installed. You can install it by typing:apt-get install rpm# apt-get install rpm……# rpm -qa|grep yum# yum install The program 'yum' is currently not installed. You can install it by typing:apt-get install yum# apt-get install yum……# yum install mysqlSetting up Install ProcessNo package mysql available.Nothing to do

2.改变安装情势

# apt-get install mysql-serverReading package lists... DoneBuilding dependency tree Reading state information... DoneThe following extra packages will be installed: libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5Suggested packages: libipc-sharedcache-perl tinyca mailxThe following NEW packages will be installed: libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.50 upgraded, 13 newly installed, 0 to remove and 15 not upgraded.Need to get 27.6 MB of archives.After this operation, 98.2 MB of additional disk space will be used.Do you want to continue [Y/n] yGet:1 precise-updates/main mysql-common all 5.5.52-0ubuntu0.12.04.1 [12.6 kB]Get:2 precise-updates/main libmysqlclient18 amd64 5.5.52-0ubuntu0.12.04.1 [952 kB]Get:3 precise/main libnet-daemon-perl all 0.48-1 [43.1 kB]Get:4 precise/main libplrpc-perl all 0.2020-2 [36.0 kB]Get:5 precise/main libdbi-perl amd64 1.616-1build2 [849 kB]Get:6 precise/main libdbd-mysql-perl amd64 4.020-1build2 [106 kB]Get:7 precise-updates/main mysql-client-core-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [1,948 kB]Get:8 precise/main libterm-readkey-perl amd64 2.30-4build3 [28.6 kB]Get:9 precise-updates/main mysql-client-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [8,365 kB]Get:10 precise-updates/main mysql-server-core-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [6,327 kB]Get:11 precise-updates/main mysql-server-5.5 amd64 5.5.52-0ubuntu0.12.04.1 [8,855 kB]Get:12 precise/main libhtml-template-perl all 2.10-1 [65.0 kB]Get:13 precise-updates/main mysql-server all 5.5.52-0ubuntu0.12.04.1 [10.8 kB]Fetched 27.6 MB in 0s (38.2 MB/s) Preconfiguring packages ...Selecting previously unselected package mysql-common.(Reading database ... 77501 files and directories currently installed.)Unpacking mysql-common (from .../mysql-common_5.5.52-0ubuntu0.12.04.1_all.deb) ...Selecting previously unselected package libmysqlclient18.Unpacking libmysqlclient18 (from .../libmysqlclient18_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...Selecting previously unselected package libnet-daemon-perl.Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...Selecting previously unselected package libplrpc-perl.Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...Selecting previously unselected package libdbi-perl.Unpacking libdbi-perl (from .../libdbi-perl_1.616-1build2_amd64.deb) ...Selecting previously unselected package libdbd-mysql-perl.Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ...Selecting previously unselected package mysql-client-core-5.5.Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...Selecting previously unselected package libterm-readkey-perl.Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4build3_amd64.deb) ...Selecting previously unselected package mysql-client-5.5.Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...Selecting previously unselected package mysql-server-core-5.5.Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...Processing triggers for man-db ...Setting up mysql-common (5.5.52-0ubuntu0.12.04.1) ...Selecting previously unselected package mysql-server-5.5.(Reading database ... 77879 files and directories currently installed.)Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.52-0ubuntu0.12.04.1_amd64.deb) ...Selecting previously unselected package libhtml-template-perl.Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.10-1_all.deb) ...Selecting previously unselected package mysql-server.Unpacking mysql-server (from .../mysql-server_5.5.52-0ubuntu0.12.04.1_9159金沙游艺场,all.deb) ...Processing triggers for ureadahead ...Processing triggers for man-db ...Setting up libmysqlclient18 (5.5.52-0ubuntu0.12.04.1) ...Setting up libnet-daemon-perl (0.48-1) ...Setting up libplrpc-perl (0.2020-2) ...Setting up libdbi-perl (1.616-1build2) ...Setting up libdbd-mysql-perl (4.020-1build2) ...Setting up mysql-client-core-5.5 (5.5.52-0ubuntu0.12.04.1) ...Setting up libterm-readkey-perl (2.30-4build3) ...Setting up mysql-client-5.5 (5.5.52-0ubuntu0.12.04.1) ...Setting up mysql-server-core-5.5 (5.5.52-0ubuntu0.12.04.1) ...Setting up mysql-server-5.5 (5.5.52-0ubuntu0.12.04.1) ...160928 10:56:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.160928 10:56:48 [Note] /usr/sbin/mysqld (mysqld 5.5.52-0ubuntu0.12.04.1) starting as process 6166 ...mysql start/running, process 6304Setting up libhtml-template-perl (2.10-1) ...Setting up mysql-server (5.5.52-0ubuntu0.12.04.1) ...Processing triggers for libc-bin ...ldconfig deferred processing now taking place

安装进程中输入root的密码就可以;

3.设置成功,基本配备

mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identified by '******';Query OK, 0 rows affected (0.00 sec)mysql mysql mysql mysql mysql mysql create database testdb;Query OK, 1 row affected (0.01 sec)mysql mysql mysql mysql mysql show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || testdb || performance_schema |+--------------------+4 rows in set (0.00 sec)mysql insert into mysql.user(Host,User,Password) values("%","test",password("******"));Query OK, 1 row affected, 3 warnings (0.00 sec)mysql mysql flush privileges;Query OK, 0 rows affected (0.00 sec)mysql GRANT ALL PRIVILEGES ON testdb.* TO 'test'@'% identified by '******';Query OK, 0 rows affected (0.00 sec)mysql flush privileges;Query OK, 0 rows affected (0.00 sec)

4.主题材料解决

访谈报错,网络连接报错:10038 ,telnet 不通 S1.关闭防火墙 # ufw allow 3306 ,依然极度 S2.客户网络权限已经给了 S3.查看网路消息 # netstat -ano tcp 0 0 127.0.0.1:3306 应该是绑定IP问题,改过/etc/MySQL/my.conf 找到bind-address = 127.0.0.1这一行 改为bind-address = 0.0.0.0,难题消除。 表区分轻重缓急写: 用root帐号登入后,在/etc/my.cnf 中的[mysqld]后增加加多lower_case_table_names=1,重启MYSQL服务,这时候已设置成功:不区分表名的分寸写; lower_case_table_names参数详细解释: lower_case_table_names = 0 在那之中0:区分朗朗上口写,1:不区分轻重缓急写

5.主题服务命令

# 启动MySQL$ sudo service mysql start # 关闭MySQL$ sudo service mysql stop# 重启MySQL$ sudo service mysql restart# 其他命令:$ sudo /etc/init.d/mysql start$ sudo /etc/init.d/mysql stop$ sudo /etc/init.d/mysql restart

6.卸载Mysql:

sudo apt-get autoremove mysql* --purgesudo apt-get remove apparmorsudo apt-get install mysql-server mysql-common

卸载后去除mysql相关文件

上述正是本文的全体内容,希望对大家的求学抱有助于,也期待我们不吝指教脚本之家。

本文由9159金沙游艺场-奥门金沙游艺场-[欢迎您]发布于服务器,转载请注明出处:28安装配备情势图像和文字化教育程

关键词:

17安装配置方法图文教程【9159金沙游艺场】

前言 前面安装过mysql5.6,时隔三个月,开发那边反馈需要在MySQL中处理JSON类型的数据,查看文档,JSON是在5.7支持的新...

详细>>

MySQL中触发器的基础学习教程

0.触发器的基本概念 触发器是一种特殊的存储过程,它在插入,删除或修改特定表中的数据时触发执行,它比数据库...

详细>>

MySQL中对表连接查询的大约优化学科

在MySQL中,A LEFT JOIN B join_condition执行过程如下: · 根据表A和A依赖的所有表设置表B。 · 根据LEFT JOIN条件中使用的所有...

详细>>

化解Java程序行使MySQL时重返参数为乱码的演示教

先说MySQL的字符集难题。Windows下可由此改变my.ini内的 default-character-set=utf8 //客户端的默认字符集 在MySQL客商端工具中...

详细>>