php7.4.1nts和mysql8.018及phpmyadmin5安装注意事项及下载地址
2020/05/26    标签: php    mysql    phpadmin   

phpadmin 无法登陆mysql8.0+版本

1.mysqld.exe install

2.mysqld --initialize --console

3.net start mysql //A temporary password is generated for root@localhost:N!dnauZrz3sy默认密码

3.修改密码 mysqladmin.exe -uroot -password ab12

链接:https://blog.csdn.net/youcijibi/article/details/81153789

1:mysql -u root -p

2:alter user 'root'@'localhost' identified with mysql_native_password by 'root'

phpadmin默认配置修改

链接:https://blog.csdn.net/u011125949/article/details/25715931

1:D:\phpStudy\WWW\phpMyAdmina\libraries\config.default.php $cfg['ExecTimeLimit']配置选项,默认值是300,需要修改为0,即没有时间限制。

2: D:\phpStudy\WWW\phpMyAdmina\import.php和D:\phpStudy\WWW\phpMyAdmina\libraries\classes\Export.php中 $memory_limit修改


相关文件下载地址:

链接:https://pan.baidu.com/s/1weEC2-yU_rXeW5qKp6JGgA

提取码:qyz6


mysql卸载

删除注删表 HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> MySQLD/MySQL

HEKY_LOCAL_MACHINE -> SYSTEM -> ControlSet001 -> MySQLD/MySQL

删除C:/programData/mysql文件夹

cmd 运行 sc delete MySQL