XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Changed to dedicated server and database can't connect - HELP!
Register
1
Cozzie
Changed to dedicated server and database can't connect - HELP!

  • 2008/3/8 9:56

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi there

Big problem and I am really lost. I just swictched to a dedicated server and can't connect to the database:

Going to the website gives 'db connection failed.'

If i try to connect to the database using phpMyAdmin i get 'Access Denied'.

I've checked and re-checked the username and password given to me by the web server host and I've got them correct on mainfile.php (and config.inc.php for phpmyadmin)

I'm guessing its to do with being on a dedicated server rather than shared host. It should be a managed server and the server host said they would transfer all files and set everything up but am i missing something?


Thanks a lot for any help
2
terrion
Re: Changed to dedicated server and database can't connect - HELP!

  • 2008/3/8 11:16

  • terrion

  • Friend of XOOPS

  • Posts: 299

  • Since: 2004/9/19


Are you logged in as root?
Terrion
Purchase, renew, or transfer your domain name to Ultranet Domains and get a FREE 10GB hosting account. Virtual Dedicated Servers around $35/monthly, no contract. FREE 24/7 telephone ...
3
Cozzie
Re: Changed to dedicated server and database can't connect - HELP!

  • 2008/3/8 14:03

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Hi terrion

Yeh, username for database is root
4
avtx30
Re: Changed to dedicated server and database can't connect - HELP!

  • 2008/3/8 15:38

  • avtx30

  • Not too shy to talk

  • Posts: 181

  • Since: 2006/10/12


Then please check if MySQL is running.
Xoops Demos:
http://www.nhatban.net/info/a0021.html
5
terrion
Re: Changed to dedicated server and database can't connect - HELP!

  • 2008/3/8 17:12

  • terrion

  • Friend of XOOPS

  • Posts: 299

  • Since: 2004/9/19


Is your server running any kind of control panel like cPanel or Plesk?
Terrion
Purchase, renew, or transfer your domain name to Ultranet Domains and get a FREE 10GB hosting account. Virtual Dedicated Servers around $35/monthly, no contract. FREE 24/7 telephone ...
6
Cozzie
Re: Changed to dedicated server and database can't connect - HELP!

  • 2008/3/9 1:18

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


No cpanel, no plesk (despite what the sales girl said)
7
Cozzie
Re: Changed to dedicated server and database can't connect - HELP!

  • 2008/3/10 2:48

  • Cozzie

  • Not too shy to talk

  • Posts: 133

  • Since: 2007/7/13


Now the site is working!

I changed the Database Hostname in mainfile.php from localhost to the ip address and (i think) that did it.

If anyone can explain to me why that did it it would be really helpful.

One thing remains however, I still can't use phpMyAdmin - it gives me "Access Denied". I've updated the user/password and so on but it still doesn't work. Does anyone know what the problem might be?

Thanks

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

171 user(s) are online (81 user(s) are browsing Support Forums)

Members: 0

Guests: 171

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits