mysql5.6.22 编译安装 登录显示错误 show databases 提示show 未找到命令? show databases; 是mysql里的语句吧,并不是命令,你开启mysql的时候失败了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 大神 没错 那是mysql命令 我现在mysql 进程都起来了还有我查询user表里root已经有密码了 默认生成随机密码么[root@localhost bin]# mysql -e "SELECT Host,User,Password FROM user" mysql+-----------+------+-------------------------------------------+| Host | User | Password |+-----------+------+-------------------------------------------+| localhost | root | *E12314F6F61024E3FC91CBEBC75B7E1427E66EFA || 127.0.0.1 | root | *E12314F6F61024E3FC91CBEBC75B7E1427E66EFA || ::1 | root | *E12314F6F61024E3FC91CBEBC75B7E1427E66EFA |+-----------+------+-------------------------------------------+这个是错误日志里的信息错误信息加粗的就是错误了吧 怎么改了 已经好几次重新编译了 求大神帮忙看看 ~ 大神别走啊 好几天了~ 老查资料了。150209 13:07:06 mysqld_safe mysqld from pid file /usr/etc/mysql/data/localhost.localdomain.pid ended150209 13:07:20 mysqld_safe Starting mysqld daemon with databases from /usr/etc/mysql/data2015-02-09 13:07:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2015-02-09 13:07:20 2818 [Note] Plugin 'FEDERATED' is disabled.2015-02-09 13:07:20 2818 [Note] InnoDB: Using atomics to ref count buffer pool pages2015-02-09 13:07:20 2818 [Note] InnoDB: The InnoDB memory heap is disabled2015-02-09 13:07:20 2818 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-02-09 13:07:20 2818 [Note] InnoDB: Memory barrier is not used2015-02-09 13:07:20 2818 [Note] InnoDB: Compressed tables use zlib 1.2.32015-02-09 13:07:20 2818 [Note] InnoDB: Not using CPU crc32 instructions2015-02-09 13:07:20 2818 [Note] InnoDB: Initializing buffer pool, size = 128.0M2015-02-09 13:07:20 2818 [Note] InnoDB: Completed initialization of buffer pool2015-02-09 13:07:20 2818 [Note] InnoDB: Highest supported file format is Barracuda.2015-02-09 13:07:20 2818 [Note] InnoDB: 128 rollback segment(s) are active.2015-02-09 13:07:20 2818 [Note] InnoDB: Waiting for purge to start2015-02-09 13:07:20 2818 [Note] InnoDB: 5.6.22 started; log sequence number 16263632015-02-09 13:07:20 2818 [Note] Server hostname (bind-address): '*'; port: 33062015-02-09 13:07:20 2818 [Note] IPv6 is available.2015-02-09 13:07:20 2818 [Note] - '::' resolves to '::';2015-02-09 13:07:20 2818 [Note] Server socket created on IP: '::'.2015-02-09 13:07:20 2818 [Note] /usr/etc/mysql/bin/mysqld: ready for connections.Version: '5.6.22' socket: '/usr/etc/mysql/mysqld.sock' port: 3306 Source distribution 我用重新装了一遍总算密码为空了 不过登录还是不行 日志都是看得localhost.localdomain.err这个 就是上面的错误求大神帮忙指点下思路 怎么解决 我写的那些过程 有错的么~ 我用重新装了一遍总算密码为空了 不过登录还是不行 日志都是看得localhost.localdomain.err这个 就是上面的错误求大神帮忙指点下思路 怎么解决 我写的那些过程 有错的么~把你的mysql的配置文件贴出来,应该是你配置出现的问题 你在 [root@localhost bin] 下使用 show databases? 没搞清楚自己在什么环境下吗? 感谢版主的回答 我知道是不再mysql下 但是不知道哪里错了 最后是因为没删除cmake缓存编译文件造成的 万分感谢回答~ 自己解决的~ json_decode是不是解析不了中文 为什么不用if,而用and [散分] 测试一个网站,希望大家给点意见!来者有分...... FCK编辑器提交有样式的内容,影响整体的显示效果,望高手赐教! 菜鸟问题:新窗口问题 thinkphp动态加载菜单的问题 strtok()循环后的剩余部分能够得到吗? 请问:在php中怎样才能不停的查询oracle数据库里面的值? 在php中调用com组件的问题 PHP微信公众平台开发如何实现定向发送??求大神!! 数组遍历问题 微信公众平台开发,手机发送给公众号的协议和公众号在线调试的不一样,字节数也小怎么回事?
+-----------+------+-------------------------------------------+
| Host | User | Password |
+-----------+------+-------------------------------------------+
| localhost | root | *E12314F6F61024E3FC91CBEBC75B7E1427E66EFA |
| 127.0.0.1 | root | *E12314F6F61024E3FC91CBEBC75B7E1427E66EFA |
| ::1 | root | *E12314F6F61024E3FC91CBEBC75B7E1427E66EFA |
+-----------+------+-------------------------------------------+这个是错误日志里的信息
错误信息
加粗的就是错误了吧 怎么改了 已经好几次重新编译了 求大神帮忙看看 ~ 大神别走啊 好几天了~ 老查资料了。
150209 13:07:06 mysqld_safe mysqld from pid file /usr/etc/mysql/data/localhost.localdomain.pid ended
150209 13:07:20 mysqld_safe Starting mysqld daemon with databases from /usr/etc/mysql/data
2015-02-09 13:07:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-02-09 13:07:20 2818 [Note] Plugin 'FEDERATED' is disabled.
2015-02-09 13:07:20 2818 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-02-09 13:07:20 2818 [Note] InnoDB: The InnoDB memory heap is disabled
2015-02-09 13:07:20 2818 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-02-09 13:07:20 2818 [Note] InnoDB: Memory barrier is not used
2015-02-09 13:07:20 2818 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-02-09 13:07:20 2818 [Note] InnoDB: Not using CPU crc32 instructions
2015-02-09 13:07:20 2818 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-02-09 13:07:20 2818 [Note] InnoDB: Completed initialization of buffer pool
2015-02-09 13:07:20 2818 [Note] InnoDB: Highest supported file format is Barracuda.
2015-02-09 13:07:20 2818 [Note] InnoDB: 128 rollback segment(s) are active.
2015-02-09 13:07:20 2818 [Note] InnoDB: Waiting for purge to start
2015-02-09 13:07:20 2818 [Note] InnoDB: 5.6.22 started; log sequence number 1626363
2015-02-09 13:07:20 2818 [Note] Server hostname (bind-address): '*'; port: 3306
2015-02-09 13:07:20 2818 [Note] IPv6 is available.
2015-02-09 13:07:20 2818 [Note] - '::' resolves to '::';
2015-02-09 13:07:20 2818 [Note] Server socket created on IP: '::'.
2015-02-09 13:07:20 2818 [Note] /usr/etc/mysql/bin/mysqld: ready for connections.
Version: '5.6.22' socket: '/usr/etc/mysql/mysqld.sock' port: 3306 Source distribution
我用重新装了一遍总算密码为空了 不过登录还是不行
日志都是看得localhost.localdomain.err这个 就是上面的错误求大神帮忙指点下思路 怎么解决 我写的那些过程 有错的么~
我用重新装了一遍总算密码为空了 不过登录还是不行
日志都是看得localhost.localdomain.err这个 就是上面的错误求大神帮忙指点下思路 怎么解决 我写的那些过程 有错的么~
把你的mysql的配置文件贴出来,应该是你配置出现的问题
没搞清楚自己在什么环境下吗?