位置: 编程技术 - 正文

Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程

编辑:rootadmin

推荐整理分享Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程,希望有所帮助,仅作参考,欢迎阅读内容。

文章相关热门搜索词:,内容如对您有帮助,希望把文章链接给更多的朋友!

mysql5.6.安装配置方法

1.系统基本信息查看,尝试yum安装

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 libmysqlclient 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 libmysqlclient 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. upgraded, newly installed, 0 to remove and not upgraded.Need to get .6 MB of archives.After this operation, .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.-0ubuntu0...1 [.6 kB]Get:2 precise-updates/main libmysqlclient amd 5.5.-0ubuntu0...1 [ kB]Get:3 precise/main libnet-daemon-perl all 0.-1 [.1 kB]Get:4 precise/main libplrpc-perl all 0.-2 [.0 kB]Get:5 precise/main libdbi-perl amd 1.-1build2 [ kB]Get:6 precise/main libdbd-mysql-perl amd 4.-1build2 [ kB]Get:7 precise-updates/main mysql-client-core-5.5 amd 5.5.-0ubuntu0...1 [1, kB]Get:8 precise/main libterm-readkey-perl amd 2.-4build3 [.6 kB]Get:9 precise-updates/main mysql-client-5.5 amd 5.5.-0ubuntu0...1 [8, kB]Get: precise-updates/main mysql-server-core-5.5 amd 5.5.-0ubuntu0...1 [6, kB]Get: precise-updates/main mysql-server-5.5 amd 5.5.-0ubuntu0...1 [8, kB]Get: precise/main libhtml-template-perl all 2.-1 [.0 kB]Get: precise-updates/main mysql-server all 5.5.-0ubuntu0...1 [.8 kB]Fetched .6 MB in 0s (.2 MB/s) Preconfiguring packages ...Selecting previously unselected package mysql-common.(Reading database ... files and directories currently installed.)Unpacking mysql-common (from .../mysql-common_5.5.-0ubuntu0...1_all.deb) ...Selecting previously unselected package libmysqlclient.Unpacking libmysqlclient (from .../libmysqlclient_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package libnet-daemon-perl.Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.-1_all.deb) ...Selecting previously unselected package libplrpc-perl.Unpacking libplrpc-perl (from .../libplrpc-perl_0.-2_all.deb) ...Selecting previously unselected package libdbi-perl.Unpacking libdbi-perl (from .../libdbi-perl_1.-1build2_amd.deb) ...Selecting previously unselected package libdbd-mysql-perl.Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.-1build2_amd.deb) ...Selecting previously unselected package mysql-client-core-5.5.Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package libterm-readkey-perl.Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.-4build3_amd.deb) ...Selecting previously unselected package mysql-client-5.5.Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package mysql-server-core-5.5.Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.-0ubuntu0...1_amd.deb) ...Processing triggers for man-db ...Setting up mysql-common (5.5.-0ubuntu0...1) ...Selecting previously unselected package mysql-server-5.5.(Reading database ... files and directories currently installed.)Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.-0ubuntu0...1_amd.deb) ...Selecting previously unselected package libhtml-template-perl.Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.-1_all.deb) ...Selecting previously unselected package mysql-server.Unpacking mysql-server (from .../mysql-server_5.5.-0ubuntu0...1_all.deb) ...Processing triggers for ureadahead ...Processing triggers for man-db ...Setting up libmysqlclient (5.5.-0ubuntu0...1) ...Setting up libnet-daemon-perl (0.-1) ...Setting up libplrpc-perl (0.-2) ...Setting up libdbi-perl (1.-1build2) ...Setting up libdbd-mysql-perl (4.-1build2) ...Setting up mysql-client-core-5.5 (5.5.-0ubuntu0...1) ...Setting up libterm-readkey-perl (2.-4build3) ...Setting up mysql-client-5.5 (5.5.-0ubuntu0...1) ...Setting up mysql-server-core-5.5 (5.5.-0ubuntu0...1) ...Setting up mysql-server-5.5 (5.5.-0ubuntu0...1) ... :: [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. :: [Note] /usr/sbin/mysqld (mysqld 5.5.-0ubuntu0...1) starting as process ...mysql start/running, process Setting up libhtml-template-perl (2.-1) ...Setting up mysql-server (5.5.-0ubuntu0...1) ...Processing triggers for libc-bin ...ldconfig deferred processing now taking place

Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程

安装过程中输入root的密码即可;

3.安装成功,基本配置

4.问题解决

(1)访问报错,网络连接报错: ,telnet 不通 S1.关闭防火墙 # ufw allow ,还是不行 S2.用户网络权限已经给了(rant all privileges on . to ‘root'@'%' identified by ‘youpassword' with grant option;) S3.查看网路信息 # netstat -ano tcp 0 0 .0.0.1: 应该是绑定IP问题,修改/etc/MySQL/my.conf 找到bind-address = .0.0.1这一行 改为bind-address = 0.0.0.0,问题解决。 (2)表区分大小写: 用root帐号登录后,在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1,重启MYSQL服务,这时已设置成功:不区分表名的大小写; lower_case_table_names参数详解: lower_case_table_names = 0 其中 0:区分大小写,1:不区分大小写

5.基本服务命令

6.卸载Mysql:

卸载后删除mysql相关文件(/var/lib/mysql , /etc/mysql等等,可以用 find -name mysql 查询下相关路径)

标签: Linux(Ubuntu)下Mysql5.6.28安装配置方法图文教程

本文链接地址:https://www.jiuchutong.com/biancheng/350042.html 转载请保留说明!

上一篇:Linux(Ubuntu)下mysql5.7.17安装配置方法图文教程

下一篇:mysql 5.7.16 安装配置方法图文教程(ubuntu 16.04)(mysql 5.7.33安装)

  • 个体户个税计算方法2022税率表
  • 定额征收需要建账吗
  • 母公司给子公司开票会有税务风险吗
  • 营业外收入怎么结转到本年利润
  • 发生销售退回如何开票
  • 购买土地什么时候缴纳契税
  • 起征点与免征额的区别
  • 固定资产采用工作量法计提折旧怎么算
  • 收保险赔偿款如何处理?
  • 营改增后房产土地作价入股该如何做税务处理?
  • 企业购买硬件与软件该如何做账?
  • 法律关系的内容是指
  • 土地转让收入怎么交所得税?
  • 固定资产验收单图片
  • 小规模纳税人收到专票后如何处理
  • windows10如何设置桌面背景
  • 股权转让要交哪些费用
  • 已达到计算机的连接数最大值win7
  • 小程序嵌入h5页面可以不写安全地址吗为什么
  • php的数组函数
  • js map foreach遍历
  • 股票发行费用怎么算
  • 企业记账的主要内容包括
  • PHP:mcrypt_ofb()的用法_Mcrypt函数
  • 房地产企业增值税扣除土地成本
  • 企业所得税核定征收方法有哪两种
  • 出口发票的开具时间问题
  • 用友软件怎么删除已经建立的账套
  • php数据库设计
  • ChatGPT频频发疯!马斯克警告:AI将毁灭人类
  • 微信小程序怎么制作自己的小程序
  • docker的常用命令汇总
  • php array_multisort 对数组进行排序详解及实例代码
  • 企业账户有什么好处
  • 律师事务所可不可以对外投资呢
  • 个人收入如何开出发票
  • 借款合同按什么缴纳印花税
  • 缴纳上年汇算清缴的分录
  • 企业所得税汇算清缴表
  • 现金股利要交税
  • 停工损失会计科目
  • 差旅费包括哪些费用
  • c#连接数据库的基本步骤是什么
  • sqlserver 删除数据
  • 增值税专用发票查询系统官方网站
  • 电商新规则
  • 租赁费的增值税可以抵扣吗
  • 增值税扣款了能退回吗?
  • 转让专利技术使用权是什么收入
  • 收到实务返利的发票
  • 固定资产的处理方法
  • 工程未竣工预付款怎么办
  • 电子承兑非拒付会怎么样
  • sql实用教程
  • 下载windows vista
  • solaris安装软件包
  • win10安装固态硬盘打开软件卡
  • xboxone系统更新错误
  • ngctw32.exe - ngctw32是什么进程 有什么用
  • windows10预览版怎么样
  • win7自带截图工具
  • win7开机自动弹出注册表编辑器怎么办
  • win8怎么恢复出厂设置找不到恢复环境
  • 宽带连接错误628win10
  • 向量上面有个倒着的v
  • easyui 日期格式化
  • shell脚本-lt
  • go 与 python
  • VectorField2D
  • javascript基础编程
  • 安卓版本apk
  • 安卓判断横竖屏
  • javascript设计
  • javascript详细介绍
  • js倒计时算法
  • android图片压缩库
  • 税款所属期起止日期
  • 河南地税税率怎么计算
  • 租的土地自己盖的厂房,厂房怎么摊销
  • 什么是集体约谈制
  • 免责声明:网站部分图片文字素材来源于网络,如有侵权,请及时告知,我们会第一时间删除,谢谢! 邮箱:opceo@qq.com

    鄂ICP备2023003026号

    网站地图: 企业信息 工商信息 财税知识 网络常识 编程技术

    友情链接: 武汉网站建设