List:General Discussion« Previous MessageNext Message »
From:Bruce Ferrell Date:November 1 2005 3:07am
Subject:Re: Help starting mysql
View as plain text  
Connie,

The port you have specified (1020) requires root permissions as does any 
port 1024 and below.  The normal port is 3306.  I'm suspecting that your 
mysql server installation is configured to run as mysql or some user 
other than root.  Change the port to something above 1024 and you should 
be OK.

Bruce Ferrell

Logg, Connie A. wrote:
> I have installed the following rpm's for mysql on my node
> [root@snv1 mysql]# rpm -qa | grep -i mysql
> MySQL-client-standard-5.0.15-0.rhel4
> MySQL-server-standard-5.0.15-0.rhel4
> MySQL-shared-standard-5.0.15-0.rhel4
> MySQL-devel-standard-5.0.15-0.rhel4
> 
> The node is:
> [root@snv1 mysql]# uname -a
> Linux snv1.xxx 2.6.13Fast100 #5 SMP Thu Oct 20 13:42:04 PDT 2005 x86_64 x86_64 x86_64
> GNU/Linux
> 
> And is running red hat version
> [root@snv1 mysql]# more /etc/redhat-release
> Red Hat Enterprise Linux WS release 4 (Nahant Update 2)
> 
> Have I installed the correct rpm?
> 
> And can you tell me what priv I do not have as root that gives the following message
> when I try to start mysqld_safe?
> 051031 16:06:20  mysqld started
> 051031 16:06:20  InnoDB: Started; log sequence number 0 43655
> 051031 16:06:20 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied
> 051031 16:06:20 [ERROR] Do you already have another mysqld server running on port:
> 1020 ?
> 051031 16:06:20 [ERROR] Aborting
> 
> 051031 16:06:20  InnoDB: Starting shutdown...
> 051031 16:06:22  InnoDB: Shutdown completed; log sequence number 0 43655
> 051031 16:06:22 [Note] /usr/sbin/mysqld: Shutdown complete
> 
> 051031 16:06:22  mysqld ended
> 
> I am not running another mysql server on this machine, and nothing is bound to port
> 1020.
> 
> Thanks, Connie
> Connie Logg, Network Analyst
> Stanford Linear Accelerator Center
> ph: 650-926-2879 
> "Happiness is found along the way, not at the end of the road, and 'IF' is the middle
> word in life."
> 
Thread
Help starting mysqlConnie A. Logg1 Nov
  • Re: Help starting mysqlBruce Ferrell1 Nov