-
编辑 删除
'mysqlbinlog' is currently not installed install mysql-server-5.5
David-VirtualBox:/usr/local/mysql/bin$ mysqlbinlog mysql-bin.000005 | moreThe program 'mysqlbinlog' is currently not installed. You can install it by typing:sudo apt-get install mysql-server-5.5[2]+ Stopped mysqlbinlog mysql-...
-
编辑 删除
Starting MySQL * Couldn't find MySQL server (/usr/bin/mysqld_safe)
*****@*****-VirtualBox:~$ sudo /etc/init.d/mysql.server startStarting MySQL * Couldn't find MySQL server (/usr/bin/mysqld_safe)解决方案：
-
编辑 删除
/sbin/insserv:No such file or directory
/sbin/insserv:No such file or directory 配置守护进程 shell>chkconfig --add mysqlderror：/sbin/insserv:No such file or directory解决方案见链接：# ln -s /usr/lib/insserv/insserv /sbin/insservｃｄ /usr/lib/insservchkconfig --add mysqld...
-
编辑 删除
insserv: Default-Stop undefined, assuming empty stop runlevel(s) for script
insserv: Default-Stop undefined, assuming empty stop runlevel(s) for script `network-interfaceshell>chkconfig --add mysqldｅｒｒｏｒ：/sbin/insserv:No such file or directoryFix:# ln -s /usr/lib/insserv/insserv /sbin/insservｃｄ /usr/lib/insserv/ins...
-
编辑 删除
Error ./bin/my_print_defaults: not found
scripts/mysql_install_db: 1: scripts/mysql_install_db: ./bin/my_print_defaults: not foundNeither host 'ubuntu' nor 'localhost' could be looked up with./bin/resolveip本人在Ubuntu12.04下安装了mysql5.5.39，安装步骤如下，到第 5 步就出bug了，1：在/home/**...
-
编辑 删除
ERROR 1045 (28000): using password: YES
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)Case 1 root@ubuntu:~# mysql -u root -p Enter password: ERROR 1045 (28000): ...
-
编辑 删除
ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sock
*****@*****-VirtualBox:~$ sudo mysql -u root -pEnter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
-
编辑 删除
mysqldump: Got error: 2002: Can't connect to local MySQL server through.....
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect最近在学习逻辑备份--mysqldump。备份一般的数据库没有问题，但是备份所有的数据库：mysqldump -uroot -p*** -all-database > /home/*****/mysql/backup/...
-
编辑 删除
mysqldump: Got error: 1168 differently defined non-MyISAM LOCK TABLES
mysqldump: Got error: 1168: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist when using LOCK TABLES备份其他的数据库可以成功。但是备份下面这个数据库starive就失败了。 备份数据库starive: sudo mysqldump -uroot -p密码 -l starive > /home/*...
-
编辑 删除
ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sock
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)自己采用的解决方案：启动MySQL数据库：***@***-VirtualBox:~$ sudo /etc/init.d/mysql.server startStarting MySQL.... * The server quit without updating PID file (/usr/local/mysql/data/***-VirtualBox.pi...
-
编辑 删除
从浏览器和记事本里 粘贴出来的SQL无法正确执行
从浏览器和记事本里 粘贴出来的SQL无法正确执行，这是为什么了？
-
编辑 删除
ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"
自己在往MySQL里面插入数据时，发现产生error: "ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"先后创建表 SC, 直到第三次才成功：点击(此处)折叠或打开CREATE TABLE SC(Sno CHAR(9) NOT NULL,cno CHAR(6) NOT NULL,Grade SMALLINT,PRIMARY KEY (Sno,cno),cons...
