博客访问： 96697
博文数量： 34
注册时间：
ITPUB论坛APP
ITPUB论坛APP
APP发帖 享双倍积分
IT168企业级官微
微信号：IT168qiye
系统架构师大会
微信号：SACC2013
分类： MySQL
CentOS 6.6下载地址
&&（minimal版）
MySQL 5.6下载地址
使用wget&直接在CentOS上下载MySQL（server、client）
若提示wget：command not found，则需先安装wget。
yum install wget -y
&wget安装好后，接下来即可继续MySQL下载
wget /Downloads/MySQL-5.6/MySQL-server-5.6.23-1.rhel5.x86_64.rpm
安装时若提Failed depaendencies:/usr/bin/perl is needed by MySQL-.......，则需安装perl
yum install perl -y
rpm -ivh& MySQL-server-5.6.23-1.rhel5.x86_64.rpm
rpm -ivh& MySQL-server-5.6.23-1.rhel5.x86_64.rpm
conflicts with file from package mysql-libs-5.1.....
包冲突，需将老版本的包卸载（删除）。
&rpm -e& mysql-libs&& --nodeps
继续安装。。。
安装完毕，启动数据库
service mysql start
查看初始密码
cat /root/.mysql_secret
mysql -uroot -p
&粘贴查看到的初始密码
set password for );
关闭mysql数据库
service mysql stop
卸载mysql数据库
rpm -e MySQL-server
rpm -e MySQL-client
阅读(7486) | 评论(0) | 转发(0) |
相关热门文章
给主人留下些什么吧！~~
请登录后评论。CentOS下mysql数据库文件全部丢失mysql无法启动
CentOS重启后mysql数据库文件全部丢失mysql无法启动
一早起来，发现数据目录下的mysql文件全部消失，一声冷汗，怎么回事！！？？？被黑了，还是因为前两天重启服务器导致mysql数据丢失？？？这是怎么回事，上网看看怎么解决，没找到解决方案！！！！看看mysql服务是不是开启的，
[root@pacteralinux mysql]# ps -ef|grep mysql
root&&&&& :10pts/000:00:00grep mysql
[root@pacteralinux mysql]# service mysqld start
Starting MySQL..The server quit without updating PID file (/mnt/resource/mysqldate/pacteralinux.pid).[FAILED]，服务关闭，而且启动不了！看日志：
:57mysqld_safe Starting mysqld daemon withdatabases from /mnt/resource/mysqldate
3:10:580[Warning] TIMESTAMP withimplicit DEFAULT value isdeprecated. Pleaseuse--explicit_defaults_for_timestamp server option (see documentation formore details).
3:10:585650[Note] Plugin 'FEDERATED'isdisabled.
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin'doesn't exist Linux学习，http:// linux.
3:10:585650[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
3:10:585650[Note] InnoDB: The InnoDB memory heap isdisabled
3:10:585650[Note] InnoDB: Mutexes and rw_locks useGCC atomic builtins
3:10:585650[Note] InnoDB: Compressed tables usezlib 1.2.3
3:10:585650[Note] InnoDB: Not using CPU crc32 instructions
3:10:585650[Note] InnoDB: Initializing buffer pool, size = 128.0M
3:10:585650[Note] InnoDB: Completed initialization of buffer pool
3:10:585650[Note] InnoDB: The first specified data file ./ibdata1 did not exist: a newdatabase to be created!
3:10:585650[Note] InnoDB: Setting file ./ibdata1 size to 12MB
3:10:585650[Note] InnoDB: Database physically writes the file full: wait...
3:10:585650[Note] InnoDB: Setting log file ./ib_logfile101 size to 48MB
3:10:585650[Note] InnoDB: Setting log file ./ib_logfile1 size to 48MB Linux学习，http:// linux.
3:10:585650[Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
3:10:585650[Warning] InnoDB: New log files created, LSN=45781
3:10:585650[Note] InnoDB: Doublewrite buffer not found: creating new
3:10:585650[Note] InnoDB: Doublewrite buffer created
3:10:585650[Note] InnoDB: 128rollback segment(s) are active.
3:10:595650[Warning] InnoDB: Creating foreign key constraint system tables.
3:10:595650[Note] InnoDB: Foreign key constraint system tables created
3:10:595650[Note] InnoDB: Creating tablespace and datafile system tables.
3:10:595650[Note] InnoDB: Tablespace and datafile system tables created.
3:10:595650[Note] InnoDB: Waiting forpurge to start
3:10:595650[Note] InnoDB: 5.6.14 log sequence number 0
3:10:595650[Note] Server hostname (bind-address): '*'; port: 3306
3:10:595650[Note] IPv6 isavailable. IT网，http://www.
3:10:595650[Note]&& - '::'resolves to '::';
3:10:595650[Note] Server socket created on IP: '::'.
3:10:595650[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
:59mysqld_safe mysqld from pid file /mnt/resource/mysqldate/pacteralinux.pid ended
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist：表初始化没做好;不管，下意识的删除日志看下能不能重启
&[root@pacteralinux mysqldate]# ll
total 110640
-rw-rw----. 1mysql mysql&&&&&& 56Nov f
-rw-rw----. 1mysql mysql Nov 2613:15ibdata1
-rw-rw----. 1mysql mysql Nov 2613:15ib_logfile0
-rw-rw----. 1mysql mysql Nov 2613:10ib_logfile1
-rw-rw----. 1mysql root&&&& 39056Nov 2613:15pacteralinux.err IT网，http://www.
[root@pacteralinux mysqldate]# rm ib*
rm: remove regular file `ibdata1'? y
rm: remove regular file `ib_logfile0'? y
rm: remove regular file `ib_logfile1'? y
不行，网上看看能不能恢复数据，无解决方案！！
幸好这时一个mysql从服务器（我做了一个主从mysql热备份）！！！没办法，数据恢复不了就重新在复制一份吧！
上述步骤后还是不能启动数据
试试重新初始化：
[root@pacteralinux mysqldate]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/data/ --datadir=/mnt/resource/mysqldate/
FATAL ERROR: Could not find ./bin/my_print_defaults
If you compiled from source, you need to run 'make install'to
copy the software into the correct location ready foroperation.
If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.
[root@pacteralinux mysqldate]# cd /usr/local/mysql/bin/
[root@pacteralinux mysql]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --no-defaults Linux学习，http:// linux.
Installing MySQL system tables...3:20:420[Warning] TIMESTAMP withimplicit DEFAULT value isdeprecated. Please use--explicit_defaults_for_timestamp server option (see documentation formore details).
3:20:426036[Note] InnoDB: The InnoDB memory heap isdisabled
3:20:426036[Note] InnoDB: Mutexes and rw_locks useGCC atomic builtins
3:20:426036[Note] InnoDB: Compressed tables usezlib 1.2.3
3:20:426036[Note] InnoDB: Not using CPU crc32 instructions
3:20:426036[Note] InnoDB: Initializing buffer pool, size = 128.0M
3:20:426036[Note] InnoDB: Completed initialization of buffer pool
3:20:426036[Note] InnoDB: Highest supported file format isBarracuda.
3:20:426036[Note] InnoDB: 128rollback segment(s) are active.
3:20:426036[Note] InnoDB: Waiting forpurge to start
3:20:426036[Note] InnoDB: 5.6.14 log sequence number 1600607 IT网，http://www.
3:20:426036[Warning] InnoDB: Cannot open table mysql/innodb_table_stats from theinternaldata dictionary of InnoDB though the .frm file forthe table exists. See /doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
ERROR: 1146Table 'mysql.innodb_table_stats'doesn't exist
3:20:426036[ERROR] Aborting
3:20:426036[Note] Binlog end
3:20:426036[Note] InnoDB: FTS optimize thread exiting.
3:20:426036[Note] InnoDB: Starting shutdown...
3:20:446036[Note] InnoDB: S log sequence number 1600617
3:20:446036[Note] ./bin/mysqld: Shutdown complete初始化不了，，删除之前初始化的文件试试
[root@pacteralinux data]# ll
drwx------. 2mysql mysql 4096Sep 2512:27mysql
drwx------. 2mysql mysql 4096Sep 2512:27performance_schema
drwxr-xr-x. 2mysql mysql 4096Sep 2510:28test Linux学习，http:// linux.
[root@pacteralinux data]# cd ..
[root@pacteralinux mysql]# rm -rf data/
重新初始化：
&[root@pacteralinux mysql]# scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/mnt/resource/mysqldate --user=mysql
Installing MySQL system tables...3:41:480[Warning] TIMESTAMP withimplicit DEFAULT value isdeprecated. Please use--explicit_defaults_for_timestamp server option (see documentation formore details).
3:41:486768[Note] InnoDB: The InnoDB memory heap isdisabled
3:41:486768[Note] InnoDB: Mutexes and rw_locks useGCC atomic builtins
3:41:486768[Note] InnoDB: Compressed tables usezlib 1.2.3
3:41:486768[Note] InnoDB: Not using CPU crc32 instructions
3:41:486768[Note] InnoDB: Initializing buffer pool, size = 128.0M
3:41:486768[Note] InnoDB: Completed initialization of buffer pool
3:41:486768[Note] InnoDB: Highest supported file format isBarracuda. IT网，http://www.
3:41:486768[Note] InnoDB: Log scan progressed past the checkpoint lsn 49463
3:41:486768[Note] InnoDB: Database was not shutdown normally!
3:41:486768[Note] InnoDB: Starting crash recovery.
3:41:486768[Note] InnoDB: Reading tablespace information from the .ibd files...
3:41:486768[Note] InnoDB: Restoring possible half-written data pages
3:41:486768[Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600617
3:41:486768[Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress inpercent:
InnoDB: Apply batch completed
3:41:486768[Note] InnoDB: 128rollback segment(s) are active.
3:41:486768[Note] InnoDB: Waiting forpurge to start IT网，http://www.
3:41:486768[Note] InnoDB: 5.6.14 log sequence number 1600617
3:41:546768[Note] Binlog end
3:41:546768[Note] InnoDB: FTS optimize thread exiting.
3:41:546768[Note] InnoDB: Starting shutdown...
3:41:556768[Note] InnoDB: S log sequence number 1625997
Filling help tables...3:41:550[Warning] TIMESTAMP withimplicit DEFAULT value isdeprecated. Please use--explicit_defaults_for_timestamp server option (see documentation formore details).
3:41:556793[Note] InnoDB: The InnoDB memory heap isdisabled
3:41:556793[Note] InnoDB: Mutexes and rw_locks useGCC atomic builtins
3:41:556793[Note] InnoDB: Compressed tables usezlib 1.2.3
3:41:556793[Note] InnoDB: Not using CPU crc32 instructions
3:41:556793[Note] InnoDB: Initializing buffer pool, size = 128.0M
3:41:556793[Note] InnoDB: Completed initialization of buffer pool Linux学习，http:// linux.
3:41:556793[Note] InnoDB: Highest supported file format isBarracuda.
3:41:556793[Note] InnoDB: 128rollback segment(s) are active.
3:41:556793[Note] InnoDB: Waiting forpurge to start
3:41:556793[Note] InnoDB: 5.6.14 log sequence number 1625997
3:41:556793[Note] Binlog end
3:41:556793[Note] InnoDB: FTS optimize thread exiting.
3:41:556793[Note] InnoDB: Starting shutdown...
3:41:576793[Note] InnoDB: S log sequence number 1626007
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place foryour system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To doso, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h pacteralinux password 'new-password' Linux学习，http:// linux.
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.& This is
strongly recommended forproduction servers.
See the manual formore instructions.
You can start the MySQL daemon with:
cd . ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon withmysql-test-run.pl
cd mysql- perl mysql-test-run.pl
Please report any problems withthe ./bin/mysqlbug script!
The latest information about MySQL isavailable on the web at
Support MySQL by buying support/licenses at
WARNING: Found existing config file /usr/local/f on the system.
Because thisfile might be inuse, it was not replaced,
but was used inbootstrap (unless you used --defaults-file)
and when you later start the server.
The newdefaultconfig file was created as/usr/local/mysql/f, Linux学习，http:// linux.
please compare it withyour file and take the changes you need.
WARNING: Default config file /f exists on the system
This file will be read by defaultby the MySQL server
If you donot want to usethis, either remove it, or usethe
--defaults-file argument to mysqld_safe when starting the server
重新启动mysql
&[root@pacteralinux scripts]# service mysqld start
Starting MySQL.[& OK& ]
[root@pacteralinux mysql]# ps -ef|grep msyql
root&&&&& & 0 14:08 pts/100:00:00 grepmsyql
[root@pacteralinux mysql]# ps -ef|grep mysql
root&&&&& 6838&&&& 1& 0 13:42 pts/100:00:00 /bin/sh/usr/local/mysql/bin/mysqld_safe--datadir=/mnt/resource/mysqldate--pid-file=/mnt/resource/mysqldate/pacteralinux.pid
mysql&&&& & 0 13:42 pts/100:00:00 /usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/mnt/resource/mysqldate--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql --log-error=/mnt/resource/mysqldate/pacteralinux.err --pid-file=/mnt/resource/mysqldate/pacteralinux.pid --socket=/mnt/resource/mysqldate/mysql.sock --port=3306 Linux学习，http:// linux.
root&&&&& & 0 14:08 pts/100:00:00 grepmysql
可以看到，mysql安装路径为--basedir=/usr/local/mysql，初始数据库的存放目录为--datadir=/mnt/resource/mysqldate
-rw-rw----. 1 mysql mysql&& 2048 Nov 26 13:41 user.MYI
[root@pacteralinux mysql]# pwd
/mnt/resource/mysqldate/mysql
[root@pacteralinux mysql]# cd ..
[root@pacteralinux mysqldate]# ll
total 110664
-rw-rw----. 1 mysql mysql&&&&&& 56 Nov 25 17:f
-rw-rw----. 1 mysql mysql
Nov 26 13:42 ibdata1
-rw-rw----. 1 mysql mysql
Nov 26 13:42 ib_logfile0
-rw-rw----. 1 mysql mysql
Nov 26 13:39 ib_logfile1
drwx------. 2 mysql mysql&&&& 4096 Nov 26 13:41 mysql
srwxrwxrwx. 1 mysql mysql&&&&&&& 0 Nov 26 13:42 mysql.sock
-rw-rw----. 1 mysql root&&&& 46096 Nov 26 13:42 pacteralinux.err Linux学习，http:// linux.
-rw-rw----. 1 mysql mysql&&&&&&& 5 Nov 26 13:42 pacteralinux.pid
drwx------. 2 mysql mysql&&&& 4096 Nov 26 13:41 performance_schema
drwx------. 2 mysql mysql&&&& 4096 Nov 26 13:41 test
其中，mysql，performance_schema，test为初始化后的文件
下面开始恢复数据库
登录到生产服务器执行备份：
&[root@uyhd000225 ~]# mysqldump -u***** -p***** mysqldb &mysqldb.sql& #数据库比较大，大约半小时
复制到备份服务器：
[root@uyhd000225 ~]# scp mysqldb.sql root@remoteIP:/mnt/backup/
root@remoteIP's password:
mysqldb.sql&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& 3%& 153MB 680.6KB/s 1:43:33ETA IT网，http://www.
(责任编辑：IT)
------分隔线----------------------------
今天例行查看服务器日志，发现了如下所示的日志，重要的日志内容是Temperature above ...
之前有哥们的VPS突然悲剧了..也是求救不够惨大神..如下是恢复结果 首先弄个跟原来系统...
其实只需要一步即可： 在window-〉Translation中，character set 中,把Use font encod...
从这个错误上是说打不开这个文件, 和配置: ---------------- 限制用户只能访问配置的...
CentOS 6.5服务器VNC远程桌面连接出错怎么办？ CentOS 6.5连接出错的原因可能不止一个...解决CentOS下mysql启动失败_centos_ThinkSAAS
解决CentOS下mysql启动失败
解决CentOS下mysql启动失败
内容来源： 网络
service mysqld start
命令启动mysql失败
查看mysql日志
tail -n 10 /var/log/mysql.log
160702 04:41:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
4:41:17 [Warning] &--default-character-set& is deprecated and will be removed in a future release. Please use &--character-set-server& instead.
Unknown suffix & & used for variable &lower_case_table_names& (value &1
//表名不区分大小写（此与编码无关）&)
4:41:17 [ERROR] /usr/libexec/mysqld: Error while setting value &1
//表名不区分大小写（此与编码无关）& to &lower_case_table_names&
4:41:17 [ERROR] Aborting
160702 04:41:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
原来是之前修改配置文件惹得祸
vim /etc/my.cnf
修改配置参数，修改对应的[mysqld]节点下的： lower_case_table_names=1一行
去掉多余的注释后可以正常启动
但是执行查询语句时select * from A1;报错a1
没办法，手起刀落人抬走，dd（vim）删掉那一行，搞定！
PHP开发框架
开发工具/编程工具
服务器环境
ThinkSAAS商业授权：
ThinkSAAS为用户提供有偿个性定制开发服务
ThinkSAAS将为商业授权用户提供二次开发指导和技术支持
让ThinkSAAS更好，把建议拿来。
开发客服微信centos 7.0编译安装mysql5.6.22 怎么进入mysql 不是安全模式下安装
- ThinkPHP框架
mysql 正常可以启动
[root@localhost data]# service mysql start
Starting MySQL. SUCCESS!
一登陆就这样的 用空密码登录的话
显示数据库什么的操作都提示找不到
[root@localhost scripts]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.
Your MySQL connection id is 1
Server version: 5.6.22 Source distribution
Copyright (c) , 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
然后就是找不到了
[root@localhost bin]# show databa
-bash: show: 未找到命令
下面这个是编译mysql的选项cmake&\&
-DCMAKE_INSTALL_PREFIX=/usr/etc/mysql&
-DMYSQL_DATADIR=/usr/etc/mysql/data&
-DSYSCONFDIR=/etc/mysql/&
-DWITH_MYISAM_STORAGE_ENGINE=1&
-DWITH_INNOBASE_STORAGE_ENGINE=1&
-DWITH_HEAP_STORAGE_ENGINE=1&
-DWITH_PARTITION_STORAGE_ENGINE=1&
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock&
-DMYSQL_TCP_PORT=3306&
-DENABLED_LOCAL_INFILE=1&
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk&
-DDEFAULT_CHARSET=utf8&
-DDEFAULT_COLLATION=utf8_general_ci这里是详细的过程记录 到底哪里的问题呢
有没有朋友遇到呢
/xxx91hx/p/4256519.html
xuechao2008
ThinkPHP 是一个免费开源的，快速、简单的面向对象的 轻量级PHP开发框架 ，创立于2006年初，遵循Apache2开源协议发布，是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则，在保持出色的性能和至简的代码的同时，也注重易用性。并且拥有众多的原创功能和特性，在社区团队的积极参与下，在易用性、扩展性和性能方面不断优化和改进，已经成长为国内最领先和最具影响力的WEB应用开发框架，众多的典型案例确保可以稳定用于商业以及门户级的开发。}