LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-26-2007, 07:34 AM   #1
undnyc
LQ Newbie
 
Registered: Jan 2007
Posts: 9

Rep: Reputation: 0
mysql as subdomain


how can i setup mysql as subdomain.... so i could access it thru navicat mysql.mydoomain.com port 3306? is it even possible?
Ohh yea i have Suse 10.1 Apacher 2.2.0 Mysql 5.....
Thanx in advance.....
 
Old 01-26-2007, 04:28 PM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,793

Rep: Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590
Quote:
how can i setup mysql as subdomain.... so i could access it thru navicat mysql.mydoomain.com port 3306?
If you mean that you want to point your browser to mysql.mydoomain.com:3306 to access mysql, then you can't, since 3306 is the port used by default by the mysql daemon (mysqld), except if you change that default port. What you can do, is to create the subdomain mysql.mydoomain.com pointing to your box running apache, setup a vhost (mysql.mydoomain.com) in apache and install phpMyadmin in the DocumentRoot of that vhost.

Last edited by bathory; 01-26-2007 at 04:30 PM.
 
Old 01-26-2007, 05:06 PM   #3
undnyc
LQ Newbie
 
Registered: Jan 2007
Posts: 9

Original Poster
Rep: Reputation: 0
well i have this program called Navicat....and it requires connection with mysql server....but everytime i try to connect it gives me some error that cannot connect to the server
 
Old 01-27-2007, 08:09 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,793

Rep: Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590Reputation: 1590
You must make sure that the mysql server is running, that you use the correct username/password to access it and if you are connecting to a remote that server, that there is no firewall blocking the connection and the mysql-user has the privileges to remotely access the server.
 
Old 01-27-2007, 09:11 PM   #5
chanbkhn
LQ Newbie
 
Registered: Jan 2007
Posts: 3

Rep: Reputation: 0
um , I am trying ... Thank you !
 
Old 01-28-2007, 10:37 AM   #6
undnyc
LQ Newbie
 
Registered: Jan 2007
Posts: 9

Original Poster
Rep: Reputation: 0
still no luck mysql server is running cannot login with navicat....
maybe i should re install mysql?'?????
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
named and subdomain trebek Linux - Networking 8 11-15-2006 02:26 AM
Subdomain->IP? johndmann Linux - Networking 5 04-03-2006 04:09 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
Subdomain help DoobyWho Linux - General 3 04-14-2003 06:51 PM
subdomain deepak Linux - Networking 2 03-01-2001 09:50 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:48 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration