服务器 – 在Ubuntu 16.04上安装mySql时出错
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了服务器 – 在Ubuntu 16.04上安装mySql时出错,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3572字,纯文字阅读大概需要6分钟。
内容图文
![服务器 – 在Ubuntu 16.04上安装mySql时出错](/upload/InfoBanner/zyjiaocheng/896/177d5f2f23b44fd89336ba7a7519ff16.jpg)
我一直按照this page上的说明在Ubuntu 16.04上安装mysql.
我在标题为“MySQL”的部分的那一页
安装和配置“我运行命令sudo apt-get install mysql-server.但是我遇到了一个错误,这是我终端中该错误的输出:
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 41515 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.7.12-0ubuntu1_all.deb ...
Unpacking mysql-common (5.7.12-0ubuntu1) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.12-0ubuntu1_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.12-0ubuntu1) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-common (5.7.12-0ubuntu1) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-5.7.
(Reading database ... 41563 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.12-0ubuntu1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.12-0ubuntu1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.12-0ubuntu1_all.deb ...
Unpacking mysql-server (5.7.12-0ubuntu1) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for systemd (229-4ubuntu4) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-client-5.7 (5.7.12-0ubuntu1) ...
Setting up mysql-server-5.7 (5.7.12-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
mysql_upgrade: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) while connecting to the MySQL server
Upgrade process encountered error and will not continue.
mysql_upgrade failed with exit status 11
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configure):
dependency problems - leaving unconfigured
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for systemd (229-4ubuntu4) ...
Errors were encountered while processing:
mysql-server-5.7
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
这是我第一次设置服务器并安装mysql.不确定这是否可能是导致错误的原因,但我以前曾尝试安装mysql但不遵循LAMP流程(我是新手搞清楚)并且这是不成功的,我不得不卸载.
解决方法:
这个答案也是对16.04 upgrade broke mysql-server的答案,但由于管理员将其锁定为10个声誉,我无法回答.
APT中的错误发生在Ubuntu升级到16.04(xenial)和Mysql从5.5升级到5.7期间.由于一些打包问题,APT升级结束,因为Mysql-server-5.7的安装后脚本无法完成.
要解决此问题,请尝试以下步骤:
> apt purge mysql-server和apt autoremove来清除旧MYSQL的所有痕迹.数据库数据不会被销毁.
>从/ etc / mysql目录中删除所有内容.
>确认没有安装旧的Mysql软件包:dpkg -l | grep mysql
> apt安装mysql-server进行安装
如果这些步骤以相同的不完整安装结束,请尝试下一步:
>尾巴-n 20 /var/log/mysql/error.log
>错误可能是
一个. debian-sys-maint的密码错误
湾Innodb没有记忆
解决2a:你需要将Mysql系统表从5.5升级到5.7
编辑my.cnf以包含'[mysqld]’行“skip-grant-tables”,服务mysql start和mysql_upgrade –force -u root -p
解决2b:你的Mysql Innodb池内存不足(你在微型服务器上吗?)
编辑my.cnf以包含在'[mysqld]’行下
innodb_buffer_pool_size = 20M
默认的innodb池是128M,在512M VM中很紧
要清除APT错误,请再次安装
dpkg --configure -a
内容总结
以上是互联网集市为您收集整理的服务器 – 在Ubuntu 16.04上安装mySql时出错全部内容,希望文章能够帮你解决服务器 – 在Ubuntu 16.04上安装mySql时出错所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。