I have taken the the following steps to transfer my sql database but yet I receive an error on the importing of the database onto the new server. It does not seem to recognize my username or password.
我已经采取了以下步骤来传输我的sql数据库但是我收到了将数据库导入新服务器的错误。它似乎无法识别我的用户名或密码。
I think the problem is being caused by phpMyAdmin privilege settings. I am transferring my sql file from a server that runs phpMyAdmin (hostgator) to an unmanaged web server.
我认为问题是由phpMyAdmin权限设置引起的。我将我的sql文件从运行phpMyAdmin(hostgator)的服务器转移到非托管Web服务器。
Here are the steps I took
以下是我采取的步骤
mysqldump -u root_wrdp1 -p --opt root_wrdp1 > root_wrdp1.sql
Enter password:
I then scp'd the sql file to my new web server (that does not run phpMyAdmin).
然后我将sql文件scp到我的新Web服务器(不运行phpMyAdmin)。
scp rbl91_wrdp1.sql root@ip.of.the.server:~/
Then I did the updating of the database on the web server without phpmyadmin...
然后我在没有phpmyadmin的情况下在Web服务器上更新了数据库...
root@www:~# mysql -u root_wrdp1 -p root_wrdp1 < ~/root_wrdp1.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'root_wprd1'@'localhost' (using password: YES)
The support by the site offered this advice but I have no idea how to implement the steps.
该网站的支持提供了这个建议,但我不知道如何实施这些步骤。
It's possible you have to review the authorization locations, such as the source location (IP) of the remote side.
您可能需要查看授权位置,例如远程端的源位置(IP)。
Using phpMyAdmin i believe the page is Priviliages , and you will also need to flush them after changing.
使用phpMyAdmin我相信该页面是Priviliages,您还需要在更改后刷新它们。
Thanks Support
1 个解决方案
#1
0
It's a simple authentication problem. Most likely the "root_wrp1" account or password are set up incorrectly on the destination machine. You can check it just by trying to log in without importing the dump file:
这是一个简单的身份验证问题。很可能在目标计算机上错误地设置了“root_wrp1”帐户或密码。您可以通过尝试登录而不导入转储文件来检查它:
$ mysql -u root_wrdp1 -p root_wrdp1
The account and password need to be set up and have adequate permissions to the database before you can restore the dump file.
在还原转储文件之前,需要设置帐户和密码并对数据库具有足够的权限。
#1
0
It's a simple authentication problem. Most likely the "root_wrp1" account or password are set up incorrectly on the destination machine. You can check it just by trying to log in without importing the dump file:
这是一个简单的身份验证问题。很可能在目标计算机上错误地设置了“root_wrp1”帐户或密码。您可以通过尝试登录而不导入转储文件来检查它:
$ mysql -u root_wrdp1 -p root_wrdp1
The account and password need to be set up and have adequate permissions to the database before you can restore the dump file.
在还原转储文件之前,需要设置帐户和密码并对数据库具有足够的权限。