Mysql connect


#1

Hi,

Just switched over to dream host, its pretty nice stuff! but i got a problem getting to phpmyadmin or connecting from cocoa…

I’m migrating a site over so currently the domain name is say… kahodomain.com

I signed up for a dream host account with a static ip 123.123.123.123

so in my host file if I add kahodomain.com 123.123.123.123 I can hit the dreamhost server. which is perfect. BUT

when I add mysql.kahodomain.com 123.123.123.123 to the host file and try to hit it, it just hits the same page instead of brining me to a phpmyadmin page. I added my home computer to the IP access but still no avail.

Not sure what I have to do here to get to phpmyadmin as I need to migrate of my db before I point the domain over.

Any help will be awesome, feel free to email me too!


#2

The static IP is only for your hosting. You MySQL will still be on a shared server.

Unless you move to PS or dedicated server.

$50 off and 3 free domains with code: [color=#CC0000]DH3[/color] Sign Up NOW or More Codes Here


#3

so how do I access this shared server? w.o. having the dns pointing?

Thanks


#4

I don’t know why you want to run PHPMySQLAdmin from your local machine.

If you just want to use PHPMySQLAdmin, you can try DH panel --> Goodies --> Manage MySQL --> PHPMySQLAdmin. It links to your database.

$50 off and 3 free domains with code: [color=#CC0000]DH3[/color] Sign Up NOW or More Codes Here


#5

Oh sorry for any confusion. I’m not trying to install phpmyadmin on my local machine, im trying to access phpymyadmin like you said.

The problem the domain is not pointing to dream host at the moment, its still pointing to a different production server. so clicking on phpmyadmin in the control panel does nothing but shoot up an error

I want to access phpmyadmin on dreamhost BUT I dont know how to without pointing the dns to dream host. The reason i cant point the dns over is because that server is still in production and the new data has not been migrated over.

Sorry if it sounded confusing.

Thanks man!


#6

There is a neat little “hack” you can use while you wait for your hostname dns to be available (or if you have not yet changed it).

Once you have created your database in the DreamHost panel, and defined a hostname, if your hostname is “mysql.yourdomain.com”, you can access it via phpmyadmin with the url:

http://www.dreamhost.com/dh_phpmyadmin/mysql.yourdomain.com/

(This tip is also available in the DreamHost wiki here)

–rlparker
–DreamHost Tech Support


#7

alright got it working … sort of.

So I can now connect to mysql. BUT when i try to import my old db a 500k database :

Documentation
#1044 - Access denied for user ‘#####’@‘67.205.0.0/255.255.224.0’ to database ‘databasename’

how the heck can that happen I logged in from form control panel… am I missing something here?

thanks


#8

Is the imported database local on your DreamHost account or are you trying to import it from your old site at another Host?

What I would do is take a backup of your old database. Download it to your own PC then upload to your DreamHost account. Then from phpmyadmin you can import the local database backup.

See this wiki entry here.


Norm

Opinions are my own views, not DreamHosts’.
I am NOT a DreamHost employee OK! :@

Act on my advice at your own risk!