我这样:C:\mysql\bin>mysql -h ip -u DBName -p password DBName | mysq l -h localhost -u root -C出错提示是这样:ERROR at line 1: Unknown command '\*'.C:\mysql\bin> C:\mysql\bin>DBName 我又该怎么办呢?
哦,是这样:C:\mysql\bin>mysqldump -h ip -u DBName -p password DBName| mysql -h localhost -u root -C Enter password: mysqldump: Got error: 1045: Access denied for user: 'DBName@ip' (U sing password: NO) when trying to connectC:\mysql\bin>DBName
我现在已经知道放在远程的MYSQL数据库的IP和数据库的用户名和密码,客户要求自己用本地的MYSQL数据库来登陆和管理远程网站的MYSQL数据库。用MYSQL CC 吧。新建立一个远程的数据库,已知IP UID PWD了,肯定每问题的。然后直接就可以对远程库操作拉。另外,也可以用MYODBC远程连接过去就好。
mysqldump -h172.20.6.250 -udeveloper -p123456 --opt smis_test | mysql -hlocalhost -uroot -C smis_test说明:远程IP:172.20.6.250
数据库名:smis_test
本地数据库名:smis_test
我这样:C:\mysql\bin>mysql -h ip -u DBName -p password DBName | mysq
l -h localhost -u root -C出错提示是这样:ERROR at line 1: Unknown command '\*'.C:\mysql\bin>
C:\mysql\bin>DBName 我又该怎么办呢?
mysql -h localhost -u root -C
Enter password:
mysqldump: Got error: 1045: Access denied for user: 'DBName@ip' (U
sing password: NO) when trying to connectC:\mysql\bin>DBName