to the remote server
| User, date | Message |
|---|---|
|
Written by gilgal
5 years ago Category: Creating a connection 32 posts since Wed, 12 Dec 07 |
By sending the Database to the remote server I exported the talbes as sql. But when I attempted to open at the remote server I got: wrote: Could not connect: Access denied for user 'root'@'localhost' (using password: NO) How can this be changed? |
|
Written by kalvaro
5 years ago 442 posts since Thu, 29 Nov 07 |
localhost is not a remote server; it's your own computer. Check with your hosting provider (given that's what you actually mean) whether they allow remote connections and, if so, what's your login info: server, user and password. Very likely, the control panel of your hosting plan allows you to create users and databases. Have a look at it. |
|
Written by gilgal
5 years ago 32 posts since Wed, 12 Dec 07 |
THis is what I get: wrote: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'gillumin'@'64.191.114.150' (using password: YES) in /www/.../index.php on line 14 |
|
Written by ansgar
5 years ago 3973 posts since Fri, 07 Apr 06 |
http://www.heidisql.com/forum/viewtopic.php?t=238 |
|
Written by gilgal
5 years ago 32 posts since Wed, 12 Dec 07 |
Ok let me make myself clear. If I upload to an online host is there anything I should do to the database and the php script? |
|
Written by ansgar
5 years ago 3973 posts since Fri, 07 Apr 06 |
The message "Access denied" can have different causes, which are described here. Please check that. However, most common causes in my opinion are: - there is something wrong in the username or password you're passing in your script or client - your user-account is not allowed to connect from the specific host you're currently on (in your case that is 64.191.114.150). Solvable by editing the user account on the server. |
|
Please login to leave a reply, or register at first. |