当前位置: 首页 > news >正文

c2c网站的特点及主要功能苏州市网站建设服务

c2c网站的特点及主要功能,苏州市网站建设服务,wordpress 添加用户登录,设计师网名大全介绍了一下安装MySQL后登陆MySQL时会遇到ERROR 1045 (28000): Access denied for user rootlocalhost (using password: NO) 这个错误#xff0c;当时不知道真正的原因#xff0c;搜索了一些网上的资料#xff0c;测试验证了如何解决这个问题#xff0c;但是一直不知道具体…介绍了一下安装MySQL后登陆MySQL时会遇到ERROR 1045 (28000): Access denied for user rootlocalhost (using password: NO) 这个错误当时不知道真正的原因搜索了一些网上的资料测试验证了如何解决这个问题但是一直不知道具体的原因。今天终于把这个问题给彻底搞清楚了。下面我以MySQL 5.6.20为例子刨析一下这个错误的真正原因如下所示[rootDB-Server tmp]# rpm -ivh MySQL-server-advanced-5.6.20-1.rhel5.x86_64.rpmPreparing... ########################################### [100%]1:MySQL-server-advanced ########################################### [100%]warning: user mysql does not exist - using rootwarning: group mysql does not exist - using root2015-03-26 10:49:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2015-03-26 10:49:07 5082 [Note] InnoDB: Using atomics to ref count buffer pool pages2015-03-26 10:49:07 5082 [Note] InnoDB: The InnoDB memory heap is disabled2015-03-26 10:49:07 5082 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-03-26 10:49:07 5082 [Note] InnoDB: Memory barrier is not used2015-03-26 10:49:07 5082 [Note] InnoDB: Compressed tables use zlib 1.2.32015-03-26 10:49:07 5082 [Note] InnoDB: Using Linux native AIO2015-03-26 10:49:07 5082 [Note] InnoDB: Using CPU crc32 instructions2015-03-26 10:49:07 5082 [Note] InnoDB: Initializing buffer pool, size 128.0M2015-03-26 10:49:07 5082 [Note] InnoDB: Completed initialization of buffer pool2015-03-26 10:49:07 5082 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!2015-03-26 10:49:07 5082 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB2015-03-26 10:49:07 5082 [Note] InnoDB: Database physically writes the file full: wait...2015-03-26 10:49:07 5082 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB2015-03-26 10:49:07 5082 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB2015-03-26 10:49:08 5082 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile02015-03-26 10:49:08 5082 [Warning] InnoDB: New log files created, LSN457812015-03-26 10:49:08 5082 [Note] InnoDB: Doublewrite buffer not found: creating new2015-03-26 10:49:08 5082 [Note] InnoDB: Doublewrite buffer created2015-03-26 10:49:08 5082 [Note] InnoDB: 128 rollback segment(s) are active.2015-03-26 10:49:08 5082 [Warning] InnoDB: Creating foreign key constraint system tables.2015-03-26 10:49:08 5082 [Note] InnoDB: Foreign key constraint system tables created2015-03-26 10:49:08 5082 [Note] InnoDB: Creating tablespace and datafile system tables.2015-03-26 10:49:08 5082 [Note] InnoDB: Tablespace and datafile system tables created.2015-03-26 10:49:08 5082 [Note] InnoDB: Waiting for purge to start2015-03-26 10:49:08 5082 [Note] InnoDB: 5.6.20 started; log sequence number 02015-03-26 10:49:08 5082 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.2015-03-26 10:49:08 5082 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.A random root password has been set. You will find it in /root/.mysql_secret.2015-03-26 10:49:09 5082 [Note] Binlog end2015-03-26 10:49:09 5082 [Note] InnoDB: FTS optimize thread exiting.2015-03-26 10:49:09 5082 [Note] InnoDB: Starting shutdown...2015-03-26 10:49:10 5082 [Note] InnoDB: Shutdown completed; log sequence number 16259772015-03-26 10:49:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2015-03-26 10:49:10 5104 [Note] InnoDB: Using atomics to ref count buffer pool pages2015-03-26 10:49:10 5104 [Note] InnoDB: The InnoDB memory heap is disabled2015-03-26 10:49:10 5104 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-03-26 10:49:10 5104 [Note] InnoDB: Memory barrier is not used2015-03-26 10:49:10 5104 [Note] InnoDB: Compressed tables use zlib 1.2.32015-03-26 10:49:10 5104 [Note] InnoDB: Using Linux native AIO2015-03-26 10:49:10 5104 [Note] InnoDB: Using CPU crc32 instructions2015-03-26 10:49:10 5104 [Note] InnoDB: Initializing buffer pool, size 128.0M2015-03-26 10:49:10 5104 [Note] InnoDB: Completed initialization of buffer pool2015-03-26 10:49:10 5104 [Note] InnoDB: Highest supported file format is Barracuda.2015-03-26 10:49:10 5104 [Note] InnoDB: 128 rollback segment(s) are active.2015-03-26 10:49:10 5104 [Note] InnoDB: Waiting for purge to start2015-03-26 10:49:10 5104 [Note] InnoDB: 5.6.20 started; log sequence number 16259772015-03-26 10:49:10 5104 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.2015-03-26 10:49:10 5104 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.2015-03-26 10:49:10 5104 [Note] Binlog end2015-03-26 10:49:10 5104 [Note] InnoDB: FTS optimize thread exiting.2015-03-26 10:49:10 5104 [Note] InnoDB: Starting shutdown...2015-03-26 10:49:12 5104 [Note] InnoDB: Shutdown completed; log sequence number 1625987A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in /root/.mysql_secret.You must change that password on your first connect,no other statement but SET PASSWORD will be accepted.See the manual for the semantics of the password expired flag.Also, the account for the anonymous user has been removed.In addition, you can run:/usr/bin/mysql_secure_installationwhich will also give you the option of removing the test database.This is strongly recommended for production servers.See the manual for more instructions.Please report any problems at http://bugs.mysql.com/The latest information about MySQL is available on the web athttp://www.mysql.comSupport MySQL by buying support/licenses at http://shop.mysql.comWARNING: Found existing config file /usr/my.cnf on the system.Because this file might be in use, it was not replaced,but was used in bootstrap (unless you used --defaults-file)and when you later start the server.The new default config file was created as /usr/my-new.cnf,please compare it with your file and take the changes you need.MySQL的安装日志信息中你会看到MySQL生成了root用户的随机密码(如下截图所示)并将这个随机密码放置在/root/.mysql_secret中。并且强制在第一次登陆时修改root用户的密码。Mysql 5.6及以后版本出处于安全考虑root密码不为空。所以在MySQL的安装过程中会生成一个随机密码但是对于我们这样的初学者不了解情况于是便从网上搜索如何解决问题的资料而问题关键在此很多做技术的人了解不够深入又喜欢随波逐流停留在问题的表层并未深入研究。而高手又不屑于这类简单的问题。A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in /root/.mysql_secret.You must change that password on your first connect,no other statement but SET PASSWORD will be accepted.See the manual for the semantics of the password expired flag.Also, the account for the anonymous user has been removed.知道了错误的前因后果那么很容易就搞定这个问题了。找到随机密码登录数据库后修改密码。问题解决
http://www.huolong8.cn/news/109208/

相关文章:

  • 企业网站制作商企业管理8大系统
  • 网站链群怎么做学网站开发的培训学校
  • 怎么自己做APP网站姓氏头像在线制作免费生成图片
  • 佛山新网站建设详细内容广州高端优秀网站改版设计公司
  • 英文网站建设 飞沐定制产品网站有哪些
  • 网站建设及维护业务服务合同福州做企业网站
  • 扶贫网站建设优势网络系统管理是做什么的
  • 做网站和网页小程序页面设计图片
  • 兰州网站推广百度信息流推广技巧
  • 有网站后台模板如何做数据库五百人建站
  • 为什么网站开发成本高网站顶部图片代码
  • 房产中介做网站天津商城网站建设
  • php 企业网站模板网站建设小图标
  • 网站建设与管理自简历网站维护和建设实报告
  • 免费的行情网站推荐下载安装园林景观设计公司管理流程
  • 网站做中英文英文太长怎么办近期发生的重大新闻
  • 网站建设的基本流程是怎样的毕业生 网站开发
  • 邵阳建设网站的公司网站三要素关键词 描述怎么做
  • 湖北外贸网站设计制作大连旅顺博物馆
  • 泰安招聘网网站评价及优化分析报告
  • 成都建站开发网站建设评价指标
  • 网站改版升级通知wordpress重装之后
  • 怎样创建公司网站什么是网络营销网络营销的主要工具有哪些
  • 多个网站域名 是新增接入哪些网站可以做ppt
  • 深圳做棋牌网站建设哪家公司便宜哔哩哔哩视频免费视频大全
  • 深圳网站关键词优化公司网站开发技术参考文献
  • 无锡网站推广无锡做网站在线制作电子简历
  • 送网站建设湖州网站网站建设
  • 企业网站开发报价形式网站设计特点
  • 温州15000 做网站的工作直播系统平台搭建