摘要: mysql数据原本在/var/mysql/data目录下,但是突发奇想的转到/usr/local/mysql/data 目录下。 需要进行下面几步: 1、/usr/local/mysql目录下建立data目录 cd /usr/local/msyql mkdir data 2、把MySQL服务进程停掉: service msyqld stop 3、把/var/mysql整个目录复制到/usr/local/mysql/data cp -R /var/mysql/ /usr/local/ 这样就把MySQL的数据文件移动到了/home/data/mysql 增加... 阅读全文
posted @ 2013-08-15 17:23 小名辉辉 阅读(192) 评论(0) 推荐(0) 编辑
摘要: 启动MYSQL是出现以下错误:[root@www ~]# /usr/local/webserver/mysql/bin/mysqladmin -u root -p 12345678Enter password:/usr/local/webserver/mysql/bin/mysqladmin: connect to server at ‘localhost’ failederror: ‘Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111)’Check that mysqld is running a 阅读全文
posted @ 2013-08-15 16:38 小名辉辉 阅读(544) 评论(0) 推荐(0) 编辑