distal-attribute
distal-attribute
distal-attribute
distal-attribute

to the remote server

User, date Message
Written by gilgal
6 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
6 years ago
592 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
6 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
Could not connect: Access denied for user 'gillumin'@'64.191.114.150' (using password: YES)

Written by ansgar
6 years ago
4973 posts since Fri, 07 Apr 06
http://www.heidisql.com/forum/viewtopic.php?t=238
Written by gilgal
6 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
6 years ago
4973 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.