护卫神主机大师新增MySQL失败
用护卫神主机大师新增MySQL失败,提示信息: 抱歉,MySQL数据库开设失败, 请检查以下内容:
1、系统设置中,没有配置正确MySQL安装路径 或 MySQL密码;
2、MyODBC安装不正确,下载MyODBC3.51,下载MyODBC5.2.6;
3、64位的Windows 2003,请下载MyODBC5.2.6的64位运行库;
4、用[护卫神·PHP套件]自动搭建PHP+MySQL环境, 点此下载;
5、MySQL密码加密方式,请使用MySQL4.1+,新版MyODBC需要。
6、在[服务器之家]论坛查找解决方案,点此打开;
按照前5步检查过还是添加失败,在登录phpmyadmin的时候提示登录失败, 发现在系统设置里面修改的MySQL密码并没有生效,导致无法添加MySQL数据库。
解决方法: 方法1.在护卫神主机大师的系统设置中修改为默认的MySQL密码,默认密码在护卫神主机大师的安装目录下 主机大师使用说明.txt 中, 自行查找。
方法2.在护卫神主机大师的系统设置中修改为自己设置的新密码,比如123456,然后用root账号和主机大师默认的MySQL密码登录phpmyadmin,点击左侧进入mysql数据库,在顶部点击“SQL”进入sql输入界面。输入以下命令:update user set password=password('123456') where User='root' 其中123456为你希望修改的密码,切记不要在数据库中直接手工修改密码,然后点击右下角的“执行”修改成功。接着还要进入phpmyadmin目录下的libraries目录,修改config.default.php文件。找到$cfg['Servers'][$i]['password'] = ' ', 修改为$cfg['Servers'][$i]['password'] = '123456'; 123456就是您想要的密码。 需要重启mysql后新密码才能生效
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /www/wwwroot/sutui8.com/wp-content/themes/Ality/functions.php on line 276