WampServer

you didnt mention this at all......


did you open up

config.inc.php in c:/wamp/apps/phpmyadmin


and change localhost to what u want?

it still says that im connectiong @ localhost

but did you actually add a user in mysql and change its host?

like


root@mysql.*******.com

did that it just locks me out of php and tryslogging in as @localhost

mysql.eclipsefit.com
# Server version: 5.0.24a-standard-log
# Protocol version: 10
# Server: mysql.eclipsefit.com via TCP/IP
# User: eclipsefit@babyruth.dreamhost.com
# MySQL charset: UTF-8 Unicode (utf8)

tjats wats on the top of my phpmyadmin on my online db that i have on someone elses web server
i just need hingsmaf replaced before those .coms

can i ask why you need to does this tho???
this is like this because it is onloine and not on your server



i have just tried on mine, and i can access phpmyadmin online....

it says localhost but it doesnt make any difference,,,,

it works fine locally and any website that is located on my server dont get me wrong but i have a visual basic program that will be run on different computers that need to connect to my database remotely

but u can connect to it remotely. the name localhost doesnt mean local only. its just a name.


for example ill let you connect to my phpmyadmin for a min

link>>>>[stevenmartin99.zapto.org]


dont delete anything!!!

i understand that but how would i connect to it then???? from my vb app like what would my host be????

where is your vb app? is it running on the server? or on the computer? i dunno muc about vb.


but my host is localhost... from any where i wanna connect its just localhost

its going to run off a completely seperate computer than my server and i try localhost and it doesnt work and im 100% positive im doin nothin wrong ive coded vb for years

im pretty sure localhost means that the file has to be located on the server i mean i could be wrong but im pretty sure im not yes u can access it not locally

so any ideas

What is the situation? your site [mysql.hingsmaf.com] is accessible. I don't see any problem accessing the site.

If you want to connect remotely by any remote VB, C# application to your mysql database, you need to add the GRANT statement to a mysql user such as root or other user name and on which database. Something like this:

GRANT ALL ON yourdbname.* TO 'root'@'%' IDENTIFIED BY 'rootpassword'

Another like this:

GRANT SELECT, INSERT ON yourdbname.tablename TO 'someuser'@'%' INDENTIFIED BY 'userpassword'

Or you can use phpmyadmin to compose the sql syntax for you.

i understand that but the thing is i dont have a host name to use... i cant use localhost beacause its located on a totally different computer thats y i need to change my mysql host from local host to mysql.hingsmaf.com

Then buy another host and install it on a different computer from a different network such as your work place.

Quote

its going to run off a completely seperate computer than my server

Why do you need to run your vb scripts from different computer. Remeber, when your db is opened for accessible from outside, it's not safe because it's not only you access it but some others will try to access it too. Just my 2 cents ;-)

Quote

thats y i need to change my mysql host from local host to mysql.hingsmaf.com

w/ that setup you can access your mysql through phpmyadmin, but your db is still accessed w/i your wamp, and you can NOT access it from outside

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

well i need to run my vb app from another comp becuz its for a customer that goes to houses and gives estimates for basements so there is no choice... but i can access my phpmyadmin but just under localhost, as connectiong to the db with like a web script of vb app but wen it comes to having that script or app on another computer (lets say a new site that i made and its only on that comp not my server but is set up with a domain) it cant connect to my db because my mysql is only running on localhost when i need to switch it

No problem. Make sure your mysql server runs without bind address to local host and with secured SSL enabled.