Centos 7 comes with MariaDB instead of MySQL. MariaDb is a open source equivalent to MySQL and can be installed with yum -y install mariadb-server mariadb. If you must have mysql you need to add the mysql-community repo sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm and then you can install MySQLl like you normally do.原文:http://www.cnblogs.com/juandx/p/4730902.h...
1.切换到root用户 su2. 安装mysql-serverapt install mysql-server注意:在Debian9之后,mysql被替换成mariadb。所以在terminal中键入mysql后,看到的提示符为MariaDB而不是mysql:MariaDB [(none)]> 在root用户下直接可登陆,因为root默认秘密为空root@debian:/home/dolph# tail /etc/mysql/debian.cnf
host = localhost
user = root
password =
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = lo...
今天心血来潮,想在树莓派上把mysql服务重弄回来,自从上次树莓派sd卡烧掉之后树莓派也是没怎么重弄服务了。记录一下,成成以后可能也会用到。
一、配置树莓派端服务:
1、下载mysql-server,这个软件提供mysql服务端能力,树莓派上就装这个就好。
sudo apt-get install mysql-server1
2、安装过后启动服务,这时候数据库只能通过root用户登陆,且没有密码
sudo service mysql start1
sudo mysql -u root1
这里说的root用户是数据...
我确实尝试在我的Vagrant Ubuntu 12.04 LTS虚拟机上安装mysql-server.当我这样做时,设置自动启动.我可以在Vagrant输出中看到这个:While not mandatory, it is highly recommended that you set a password ││ for the MySQL administrative “root” user.││││ If this field is left blank, the password will not be changed.││││ New password for the MySQL “root” user之后输出文字变得乱七八糟 – ├???????─...
dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfiguredstart: Job failed to startinvoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
实际上是由于mysql的手动删除是没有清除干净。
处理方法如下:
sudo rm /var/lib/mysql/ -Rsudo rm /etc/mysql/ -Rsudo apt-get autoremove mysql* --purge
然后重新安装即可
Ub...
saltstack的深入-测试saltstack配置zabbix所需的mysql-server操作内容:
一、基础环境
1、使用tvm-cobbler安装一个tvm-zabbix虚拟机来做实验。
2、网络:
eth0:host-only(用于虚拟内网,手动固定IP,这样从宿主机可以直接连接到这个vm)
eth1:NAT(用于上外网,动态IP)
[root@tvm-zabbix ~]# cd /etc/sysconfig/network-scripts/
[root@tvm-zabbix network-scripts]# cat ifcfg-eth0
DEVICE=eth0
TYPE=Ethernet
ONBOOT=yes
NM_...
Centos 7 comes with MariaDB instead of MySQL. MariaDb is a open source equivalent to MySQL and can be installed with yum -y install mariadb-server mariadb. If you must have mysql you need to add the mysql-community repo sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm and then you can install MySQLl like you normally do.No package mysql-server available.标签:本文系统...
MySQL之父Widenius先生离开了Sun之后,觉得依靠Sun/Oracle来发展MySQL,实在很不靠谱,于是决定另开分支,这个分支的名字叫做MariaDB。MariaDB跟MySQL在绝大多数方面是兼容的,对于开发者来说,几乎感觉不到任何不同。目前MariaDB是发展最快的MySQL分支版本,新版本发布速度已经超过了Oracle官方的MySQL版本。Centos yum 安装mysql报错 No package mysql-server available.标签:本文系统来源:http://www.cnblogs.com/xiaozong/p/...
[plain] view plaincopy # wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm -- http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 正在解析主机 repo.mysql.com (repo.mysql.com)... 23.4.241.142正在连接 repo.mysql.com (repo.mysql.com)|23.4.241.142|:80... 已连接。已发出 HTTP 请求,正在等待回应... 200 OK长度:6140 (6.0K) [application/x-redhat-package-manager]正在保存至: ...
第一步:下载这个包,命令为: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 第二步:安装,命令: rpm -ivh mysql-community-release-el7-5.noarch.rpm 第三步:检查安装是否成功,出现一下两个包就可以: ls -1 /etc/yum.repos.d/mysql-community* 第四步:安装mysql-server就可以了#yum install mysql-server 本文出自 “李晓东” 博客,请务必保留此出处http://lixiaodong2016.blog.51cto.com/11...
from cached hostfile
No package mysql-server available.
Error: Nothing to do原因是yum安装库里没有直接可以用的安装包,这时候就需要用到MariaDB了,MariaDB是
MySQL社区开发的分支,也是一个增强型的替代品。CentOS7安装mysql-server标签:本文系统来源:http://www.cnblogs.com/tdcqma/p/5666215.html
安装mysql和mysql-devel都成功,但是安装mysql-server失败,如下:
[root@localhost ~]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile* base: mirrors.sina.cn* extras: mirrors.sina.cn* updates: mirrors.sina.cn
No package mysql-server available.
Error: Nothing to do查资料发现是CentOS 7 版本将MySQL数据库软件从默认的程序列表中移除,用mariadb代替了
解决办法...
.repos.d]# yum install mysql-service -y
Loading "installonlyn" plugin
Setting up Install Process
Setting up repositories
c5-media 100% |=========================| 1.1 kB 00:00
Reading repository metadata in from local files
Parsing package install arguments
Nothing to do 1:安装yum仓库2:rpm-qa 查看mysql是否有[root@JW31 yum.repos.d]# rpm -qa |mysql
-bash: mysql: command not fou...
[root@yl-web yl]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.26 MySQL Community Server (GPL)Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type ‘help;‘ or...
解决步骤:
step1
mysql -u root -p # 报错
# 报错信息……
step2
sudo cat /etc/mysql/debian.conf # 查看此文件内debin-sys-maint用户的信息,这是系统自动生成的
mysql -u debin-sys-maint -p # 用debin-sys-maint 登录mysql,密码在debin.conf里面
step3 修改root用户的密码
参考mysql查看数据库、表的基本命令
mysql> show databases; # 显示数据库列表
mysql > use mysql; # 进入mysql这个数据库
mysql> sh...