位置: 编程技术 - 正文

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安装)

  • 应交税费转结哪里去
  • 公司租的住宅和商品房
  • 外国常驻代表机构办理税务登记
  • 法人怎么从公账上转账
  • 一般纳税人9个点可以抵扣吗
  • 叉车折旧年限是几年预计净残值
  • 现金日记账承前页过次页
  • 收银设备如何入账的
  • 免税商品进项增值税发票怎么做账
  • 自然人税收系统怎么添加人员
  • 资产减值损失为正
  • 核定征收可以享受小微企业税收优惠吗
  • 固定资产领用原材料要考虑增值税吗?
  • 工伤保险可以税后支付吗
  • 年内累计增量和年度增量计算公式
  • 现金买东西可以退吗
  • 旅游业差额的会计分录
  • 预缴所得税需要结转吗
  • 合并企业的增值税税率
  • 没有进出口权可以做外贸吗
  • 如何更换电脑开机动画
  • php数组实现
  • 进项发票认证后多久可以申报
  • 融资租入固定资产的账务处理
  • 企业租赁房屋怎么开发票
  • phpmemcached使用
  • 补收入的会计分录
  • 商贸企业税收优惠政策
  • framework怎么用
  • node 卸载
  • php百分比
  • 微信小程序开发一个多少钱
  • 什么叫预缴款
  • 小规模纳税人代收水电费税率
  • 公司名义送花圈
  • mac安装mysql8.0
  • 社保次月几号生效
  • 印花税购销合同计税依据
  • 小企业会计准则主要按照什么计量
  • sqlserver解密工具
  • SQL2008中通过DBCC OPENTRAN和会话查询事务
  • PostgreSQL 查看数据库,索引,表,表空间大小的示例代码
  • 同一控制下企业合并
  • 生产加工费税率
  • 固定资产盘盈为何要交所得税
  • 付款人和开票人必须相符吗
  • 企业招聘残疾人税收优惠
  • 制造费用账户在月末一般没有余额
  • 跨月开票的业务怎么做
  • 结构性存款现金流量折现法
  • 投资者投入固定资产成本
  • 利润分配明细科目有哪些
  • 预算凭证是什么
  • 购房发票丢了怎么收房
  • 承兑个人贴现如何操作
  • 餐饮服务属于什么职业
  • 城镇土地使用税减免税政策
  • 营改增后工程项目计价规则也随之发生了改变对还是错
  • Windows下安装爱思助手V8
  • 查找非空顺序表l中第一个最大的元素
  • windows找不到文件请确定文件名是否正确
  • window系统怎么更新版本
  • mac开机后蓝屏没反应
  • centos bond mode
  • win8 net framework
  • u盘制作iso镜像文件启动
  • linux网络中断
  • Windows命令行删除文件夹
  • android项目打包成jar包
  • 简述python语言
  • python对excel操作真的有提高吗
  • node.js常用命令
  • 三消游戏在线
  • python3中map
  • 预拍摄功能相机
  • 增值税发票打印机怎么连接电脑
  • 运输类税点
  • 地税税务登记代码怎么查
  • 消费税包装物押金和增值税一致吗
  • 利润表中所得税费用包括
  • 免责声明:网站部分图片文字素材来源于网络,如有侵权,请及时告知,我们会第一时间删除,谢谢! 邮箱:opceo@qq.com

    鄂ICP备2023003026号

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

    友情链接: 武汉网站建设