我正在尝试让mysql在一个VPS上运行,我已经有几个月没有使用它了(当它在工作时)。我正在使用MariaDB,所有东西都是最新的。
错误日志显示如下:
systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
systemd[1]: Failed to reset devices.list on /system.slice/mysql.service: No such file or directory
mysqld_safe: Starting mysqld daemon with
我在我的本地主机上建立了一个wordpress,而本地pc不能与互联网连接。
使用命令登录mysql数据库。
mysql -u root -p
mysql> show processlist;
+-----+------+-----------+------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+-----
我有个奇怪的问题。我已经在我的ubuntu 9.04上安装了mysql 5.1。
我用了很长时间(比如3个月),一切都很顺利。直到我面对这个非常奇怪的问题。
当我想要连接到一个随机数据库时,我会得到这样的消息:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: test_cake
ERROR 2006 (HY000): MySQL server has gone away
No connection
每当我尝试通过命令启动MySQL时
service mysqld start
我得到以下错误:
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
看看日志,我看到了这个:
150706 14:52:12 mysqld_safe The file /usr/libexec/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory a
我被设置为在ubuntu机器上创建多个实例。当我启动mysql实例时,mysqld1正在运行,但mysqld2没有运行。
root@ubuntu:/var/lib# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is not running
Below is my my.cnf file :
[client]
port = 3306
socket = /v
我遵循以下步骤:
在步骤6中,键入以下命令之后:
mysql -u root -p
我有一个错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
当我转到'/var/run/mysqld‘时,我找不到mysqld.sock,尽管在文件(/etc/mysql/my.cnf)中:
[client]
port = 3306
socket = /var/run/mysq
MySQL无法在上启动。
mysqld[3440]: [Note] /usr/bin/mysqld (mysqld 10.1.22-MariaDB) starting as process 3440 ...
mysqld[3440]: [Note] InnoDB: Using mutexes to ref count buffer pool pages
mysqld[3440]: [Note] InnoDB: The InnoDB memory heap is disabled
mysqld[3440]: [Note] InnoDB: Mutexes and rw_locks use GCC
Mysqld不重新启动日志,这显然是很明显的原因:
mysqld started
[Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line
[ERROR] /usr/libexec/mysqld: unknown variable 'password=mypassword'
mysqld ended
/etc/my.cnf没有任何相关的内容,也没有这样的变量,顺便说一下,这些变量在消息(!!?)中
现在我想在centos7上使用service mysqld start启动mysql,但我得到了以下错误:
操作系统: centos64位
Redirecting to /bin/systemctl start mysqld.service Job for mysqld.service failed.
See 'systemctl status mysqld.service andjournalctl -xn for details.
已安装以下软件,没有出现任何错误和警告:
mysql-community-bench-5.7.5-0.6.m15.el7.x86_64.rpm
m
我正在尝试配置一个MySQL服务器来运行守护进程的多个实例(我希望将它复制到不同的驱动器上)。我一直在尝试使用mysqld_multi脚本。但是,脚本没有在/etc/mysql/my.cnf中找到组。
我将配置从msqld_multi --example复制并粘贴到my.cnf中,这发现了组的fines。但是,当我试图修改下面的文件时,mysqld_multi report只显示:
Reporting MySQL servers
No groups to be reported (check your GNRs)
下面是我的my.cnf文件的缩写。
[mysqld_safe]
socket
我一直试图在上安装Apache和MySQL。不幸的是,在安装MySQL (pacman -S mysql)之后,无法启动服务。我想知道哪里出了问题。正如pacman所说的那样,删除该方案的努力是徒劳的,error: target not found: mysql说。
Start mysql (sudo systemctl start mysqld) returns:
Job for mysqld.service failed because a timeout was exceeded. See "systemctl status mysqld.service" and
Cat‘在我的archlinux x64上启动mysqld。
Job for mysqld.service failed. See "systemctl status mysqld.service" and "journalctl -xe" for details.
在systemctl start mysqld之后
在日志中
mysqld.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor p
在更新到Ubuntu16.04.1之后,尝试在服务器上安装UbuntuServer5.7时,我会收到以下消息。有人知道我该怎么纠正吗?
Renaming removed key_buffer and myisam-recover options (if present)
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for detai
我有一个运行在amazon Linux AMI上的Amazon ec2实例,它是一个微型实例。我想在我的服务器上安装Django,所以我输入了以下命令
wget http://www.mlsite.net/blog/wp-content/uploads/2008/11/go
wget http://www.mlsite.net/blog/wp-content/uploads/2008/11/django.conf
chmod 744 go
./go
所以在我完成之后,我运行了sudo service httpd restart和sudo service mysqld restart
这是mys
/var/log/mysql*中没有任何内容。
syslog显示:
Oct 25 09:55:28 mx mysqld: InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 14:55:28 UTC - mysqld got signal 11 ;
Oct 25 09:55:28 mx mysqld: This could be because you hit a bug. It is also possibl
不久前,MySQL停止了在我的服务器上的工作,我只是抽出时间研究它。
当我试着用
service mysqld start
我得到了
Starting MySQL.The server quit without updating PID file (/[FAILED]mysqld/mysqld.pid).
如果我跑了
service mysqld restart
我得到了
MySQL server PID file could not be found!
我的my.cnf文件有以下内容:
pid-file = /var/run/mysqld/mysqld.pid
/var/run/mys
我试图移动mysql的数据目录,下面是我的步骤:
使用show variables like 'datadir'知道我的datadir是/var/lib/mysql/
cd /var/lib/mysql/
# mv * /home/elderry/db/
gvim /etc/mysql/my.cnf
在[mysqld]部分添加这一行:datadir = /home/elderry/db/
# systemctl start mysqld
Job for mysqld.service failed. See 'systemctl status my
我无法干净地关闭mysql。10分钟后,关闭超时并终止该进程。我相信这是在debian jessie从5.5升级到5.6之后开始的。
停止mysql.service系统
Jan 20 09:59:32 vesuvius mysqld_safe[19606]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 20 09:59:32 vesuvius mysqld_safe[19606]: error: 'Can't connect to local MySQL server
我正在尝试在Red Hat 7上启动mysql。我删除了maria db,并按照以下说明安装了mysql:
> service mysql start
Redirecting to /bin/systemctl start mysql.service
screen hangs here...
^C
[root@abc mysql]# service mysql status
Redirecting to /bin/systemctl status mysql.service
mysqld.service - MySQL Community Server
Load
我在Debian上运行MySQL (通常是从稳定包中安装)。
每次我下大订单时,mysql都会崩溃。示例查询(innodb表):
SELECT *
FROM `table`
INNER JOIN (
SELECT `key1`,
`key2`,
MAX(`date`) AS `date`
FROM `table`
WHERE `key2` = 1 # <-- Fancy variable to get different amount of datasets
AND `someOtherIndex` >= 5
如果没有收到以下错误,我无法启动mysqld:
[root@alarm ~]# mysqld
140414 16:01:04 [ERROR] Fatal error: Please read "Security" section of the manua l to find out how to run mysqld as root!
140414 16:01:04 [ERROR] Aborting
140414 16:01:04 [Note] mysqld: Shutdown complete
如果我尝试启动mysql,它会告诉我它无法通过套接字'/run/mys
我最近安装了Arch x64,我想安装LAMP堆栈。一切都很好,直到我到达了我安装但无法启动的MySQL部件。sudo systemctl start mysqld的输出给出:
Job for mysqld.service failed because a timeout was exceeded. See "systemctl status mysqld.service" and "journalctl -xe" for details.
下面是systemctl status mysqld.service输出:
* mysqld.service - Mari
我已经安装了以下版本的MySQL:
kurt@kurt-ThinkPad:~$ mysql -V
mysql Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using EditLine wrapper
我记得我在安装过程中没有为root用户设置密码。但是,如果我试图简单地使用mysql命令启动它,我会得到以下错误:
kurt@kurt-ThinkPad:~$ mysql
ERROR 1045 (28000): Access denied for user 'kurt'@'localhost' (using pass