mamp pro中mysql报错解决
来源:互联网 发布:新日铁住金软件怎么样 编辑:程序博客网 时间:2024/05/21 10:52
报错内容
171208 16:15:54 mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error.log'.
171208 16:15:54 mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql56
2017-12-08 16:15:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-08 16:15:54 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-12-08 16:15:54 0 [Note] /Applications/MAMP/Library/bin/mysqld (mysqld 5.6.35) starting as process 4107 ...
2017-12-08 16:15:54 4107 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql56/ is case insensitive
2017-12-08 16:15:54 4107 [Note] Plugin 'FEDERATED' is disabled.
/Applications/MAMP/Library/bin/mysqld: Table 'mysql.plugin' doesn't exist
2017-12-08 16:15:54 4107 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-12-08 16:15:54 4107 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-12-08 16:15:54 4107 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-08 16:15:54 4107 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-12-08 16:15:54 4107 [Note] InnoDB: Memory barrier is not used
2017-12-08 16:15:54 4107 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-12-08 16:15:54 4107 [Note] InnoDB: Using CPU crc32 instructions
2017-12-08 16:15:54 4107 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-12-08 16:15:54 4107 [Note] InnoDB: Completed initialization of buffer pool
2017-12-08 16:15:54 4107 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-08 16:15:54 4107 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-08 16:15:54 4107 [Note] InnoDB: 5.6.35 started; log sequence number 133313511
2017-12-08 16:15:54 4107 [Note] RSA private key file not found: /Library/Application Support/appsolute/MAMP PRO/db/mysql56//private_key.pem. Some authentication plugins will not work.
2017-12-08 16:15:54 4107 [Note] RSA public key file not found: /Library/Application Support/appsolute/MAMP PRO/db/mysql56//public_key.pem. Some authentication plugins will not work.
2017-12-08 16:15:54 4107 [Note] Server hostname (bind-address): '127.0.0.1'; port: 8889
2017-12-08 16:15:54 4107 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2017-12-08 16:15:54 4107 [Note] Server socket created on IP: '127.0.0.1'.
2017-12-08 16:15:54 4107 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
171208 16:15:54 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
解决办法1
一、打开MAMP PRO,打开菜单栏File->Edit Template->MySQL->5.6.35,这时打开了一个文本,找到[mysqld],注意带上中括号,在这行下面加一行“innodb_force_recovery = 1”;二、启动mySQL,成功后再关闭;三、重新打开那个文本,删除添加的那一行;四、再打开mySQL,完毕。
解决办法2
如果解决办法一不可以的话 就使用这个办法 找到mamp pro相关的mysql文件 替换mysql中的所有文件即可解决(可能mysql中文件被毁坏了)
mysql需要文件 地址:http://download.csdn.net/download/resilient/10153437
- mamp pro中mysql报错解决
- mamp pro navicat连接mysql
- mamp pro mysql数据库位置
- Sequel Pro连接本地mamp的mysql
- MAMP PRO的mySQL启动失败
- mamp pro无法打开mysql解决办法
- PHP 连接MAMP中 MySQL失败问题的解决
- Mac 下MAMP Pro MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
- Mamp 3.5 Pro 注册码
- mamp pro破解方法
- mamp pro破解方法
- MAMP中设置Mysql root密码
- MAMP中设置Mysql root密码
- MAMP Pro 2.1.2 注册码
- MAMP PRO 4.1.1 破解
- mamp pro 4.1破解版
- Mac电脑使用MAMP PRO作为php集成环境,在连接mysql的注意点
- Mac下MAMP Pro 启动数据库MySQL出错导致无法启动的问题
- 并发队列ConcurrentLinkedQueue和阻塞队列LinkedBlockingQueue
- 如何搭建网站呢
- Mohican_12/10 C语言—分支结构
- 把 Eclipse/myeclipse 锁定到任务栏的方法
- 设计模式(三)------设计模式六大原则(2):里氏替换原则
- mamp pro中mysql报错解决
- 【配置阿里云】申请配置阿里云服务器,并部署IIS和开发环境,项目上线经验
- sql学习
- JQ坑1
- 成员变量与局部变量的区别
- 剑指offer—和为s的连续正数序列
- faster-rcnn中的RPN原理
- Android5.0及以上系统WebView上传图片遇到的那些坑
- Unix操作系统常用命令