Re: Specify which domain to connect from
At 11:27 -0400 8/24/04, Michael Stassen wrote: No, there is no option to control the client's apparent hostname. Considering that restricting the allowable connecting hosts is part of mysql's access control mechanism, this makes sense. Whether your client hostname is localhost or a domain name/ip address is controlled by your connection method. By default, mysql connects to the server on localhost via unix socket. When connecting this way, the client hostname is localhost, as well. If you specify a domain name/ip address of the server with -h, however, you connect to that server via tcp/ip, so the client hostname is your domain name/ip address. So, you can accomplish what you want. If you and the mysql server are on myhost.mydomain.com, mysql -h myhost.mydomain.com -u jonas -p connects you to the server via tcp/ip, with myhost.mydomain.com as the connecting hostname. That said, I can't think of any reason why you would want to do this. tcp/ip adds overhead, so it is less efficient. In other words, connecting to localhost is the default partly because it's better. No doubt you do have a reason for wanting this, but there may be a better solution. If you told us why you want your connection to appear to come from your hostname (tcp/ip) instead of from localhost (unix socket), someone might suggest a better way. To connect to a local server using TCP/IP, you can also specify a host of 127.0.0.1 to use the loopback interface. One reason to do this is when you are connecting to a replication master running on the same machine. If you specify "localhost", the connection tries to use the socket file and any port specification gets ignored. If you use 127.0.0.1, the port specification will be used. Michael Jonas Ladenfors wrote: Hello, Is there someway to specify which domain one would like to connect from in the mysql console. When connecting on my server I always get connected through localhost. I would like to connect through my DNS name. quasi example : mysql -u [EMAIL PROTECTED] -p regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Specify which domain to connect from
No, there is no option to control the client's apparent hostname. Considering that restricting the allowable connecting hosts is part of mysql's access control mechanism, this makes sense. Whether your client hostname is localhost or a domain name/ip address is controlled by your connection method. By default, mysql connects to the server on localhost via unix socket. When connecting this way, the client hostname is localhost, as well. If you specify a domain name/ip address of the server with -h, however, you connect to that server via tcp/ip, so the client hostname is your domain name/ip address. So, you can accomplish what you want. If you and the mysql server are on myhost.mydomain.com, mysql -h myhost.mydomain.com -u jonas -p connects you to the server via tcp/ip, with myhost.mydomain.com as the connecting hostname. That said, I can't think of any reason why you would want to do this. tcp/ip adds overhead, so it is less efficient. In other words, connecting to localhost is the default partly because it's better. No doubt you do have a reason for wanting this, but there may be a better solution. If you told us why you want your connection to appear to come from your hostname (tcp/ip) instead of from localhost (unix socket), someone might suggest a better way. Michael Jonas Ladenfors wrote: Hello, Is there someway to specify which domain one would like to connect from in the mysql console. When connecting on my server I always get connected through localhost. I would like to connect through my DNS name. quasi example : mysql -u [EMAIL PROTECTED] -p regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Specify which domain to connect from
maybe u can try: mysql -u [EMAIL PROTECTED] -p -h dnsbasedhostname --- Jonas Ladenfors <[EMAIL PROTECTED]> wrote: > Hello, Is there someway to specify which domain > one would like to connect > from in the mysql console. When connecting on my > server I always get > connected through localhost. I would like to > connect through my DNS name. > > quasi example : mysql -u [EMAIL PROTECTED] -p > > regards > /Jonas > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Specify which domain to connect from
Hello, Is there someway to specify which domain one would like to connect from in the mysql console. When connecting on my server I always get connected through localhost. I would like to connect through my DNS name. quasi example : mysql -u [EMAIL PROTECTED] -p regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]