Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th December 2011, 13:52
yvespires yvespires is offline
Junior Member
 
Join Date: Aug 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default phpmyadmin blocking remote access

Hello

I did default installation of ISPconfig, can login normally on phpmyadmin page using root... but i cannot using custom user.. gettting this error:

#1045 Cannot log in to the MySQL server


Remote Acess is checked.


Any ideas?
Reply With Quote
Sponsored Links
  #2  
Old 20th December 2011, 14:17
bruno_floyd bruno_floyd is offline
Member
 
Join Date: Aug 2010
Posts: 73
Thanks: 1
Thanked 2 Times in 2 Posts
Default

Did you add the IPs of the servers/places where the user would log in from?
Reply With Quote
  #3  
Old 20th December 2011, 14:23
yvespires yvespires is offline
Junior Member
 
Join Date: Aug 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by bruno_floyd View Post
Did you add the IPs of the servers/places where the user would log in from?
nop, i left it blank so any IP can log in

tried now via terminal:
Quote:
root@web2:~# mysql -u c18teste -p
Enter password:
ERROR 1045 (28000): Access denied for user 'c18teste'@'localhost' (using password: YES)
Reply With Quote
  #4  
Old 20th December 2011, 14:29
bruno_floyd bruno_floyd is offline
Member
 
Join Date: Aug 2010
Posts: 73
Thanks: 1
Thanked 2 Times in 2 Posts
Default

Try with the IP, see if it works
Reply With Quote
  #5  
Old 20th December 2011, 18:08
yvespires yvespires is offline
Junior Member
 
Join Date: Aug 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Figured...

I did multiserver installation...following ISPConfig manual.

web.domain.com - 192.168.0.1 / xxx.xxx.64.50
ns1.domain.com - 192.168.0.2 / xxx.xxx.64.51
ns2.domain.com - 192.168.0.3 / xxx.xxx.64.52
db.domain.com - 192.168.0.4 / only internal access

http://web.domain.com/phpmyadmin using root login works, but only lists db from web.domain.com... seems right

But when i create website database and try to login using normal user http://web.domain.com/phpmyadmin, for some reason phpmyadmin at web.domain.com cant connect to db.domain.com

is something wrong in my setup?!
Reply With Quote
  #6  
Old 20th December 2011, 19:48
yvespires yvespires is offline
Junior Member
 
Join Date: Aug 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

solved!

added db.domain.com at phpmyadmin login screen
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Info] Remote Desktop Solutions for Linux mar.and65 Desktop Operation 0 27th April 2011 07:05
Webmin upgrade lishaw1968 Installation/Configuration 15 26th August 2010 15:23
IP tables blocking remote vpn access dalitso Server Operation 14 12th January 2010 17:17
Can't Remote Access mysql 4.1 dedibox Installation/Configuration 2 24th August 2006 10:32
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 18:26


All times are GMT +2. The time now is 06:54.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.