Wolfgang Arendt Vodafone TeleCommerce GmbH SW Test & Config. Management Wolfgang Arendt Daniel-Goldbach-Str. 17-19 40880 Ratingen Tel. +49 (0) 21 02 / 97 2492 Fax +49 (0) 21 02 / 97 2453 mailto:[EMAIL PROTECTED] www.vodafone-telecommerce.de -----Ursprüngliche Nachricht----- Oops! Typo! To choose the socket do not use "/opt/mysql/var/mysql" but "/opt/mysql/var/mysql.sock"! Dave, to install mysql to run as a normal user is not that hard. Just follow these instructions Installation of mysql ------------------------------ You will create a user and a group for the mysql-user. Then you will create a directory, for the mysql-user to live in. After compiling and installation you will have to 'donate' the new directory to the user. The directory, that you will use is /opt/mysql. 1.) Make a group and a user for the mysql-user ---------------------------------------- groupadd mysql useradd -g mysql -d /opt/mysql -c "The MySQL-server" mysql ---------------------------------------- 2.) Create a home-directory for mysql ---------------------------------------- mkdir /opt/mysql ---------------------------------------- 4.) Extract the mysql-source to /usr/src and change to the top level-dir of the extracted packages You will configure the source to be installed to the /opt/mysql-directory: Change ID to root and enter: ---------------------------------------- ./configure --prefix=/opt/mysql \ --with-mysqld-user=mysql \ --with-unix-socket-path=/opt/mysql/var/mysql && make && make install && scripts/mysql_install_db && chown -R mysql.mysql /opt/mysql ---------------------------------------- Explanation: --prefix=/opt/mysql: install to this directory --with-mysqld-user=mysql: Run as user "mysql" --with-unix-socket-path=/opt/mysql/var/mysql: use this file (fifo) to communicate with the server The script mysql_install_db installs the initial databases, that contain the user and database ownership and permission system. chown -R mysql.mysql /opt/mysql: This grants the mysql-user (nearly) unlimited access to the /opt/mysql-directory In the directory /usr/src/mysql-XXX you find a script, that you can use to start and stop the mysql-daemon in the various runlevels. It is called "mysql.server". To install it, do the following: For SuSE-Linux copy it to /sbin/init.d/mysql. Then you will link it to the various runlevels: ---------------------------------------- for i in 2 3; do cd /sbin/init.d/rc$i.d && ln -s /sbin/init.d/mysql S99mysql done for i in 0 1 6 S; do cd /sbin/init.d/rc$i.d && ln -s /sbin/init.d/mysql K01mysql done ---------------------------------------- This assures, that the mysql-daemon is being started in runlevels 2 and 3. For other distributions like Red Hat do this: ---------------------------------------- for i in 3 4 5; do cd /etc/rc$i.d && ln -s /etc/init.d/mysql S99mysql done for i in 0 1 2 6; do cd /etc/rc$i.d && ln -s /etc/init.d/mysql K01mysql done ---------------------------------------- This assures, that the mysql-daemon is being started in runlevels 3 to 5. Finally, give the mysql-root-user a password: Start the mysql-daemon and log in. Then do this: ---------------------------------------- mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql> FLUSH PRIVILEGES; ---------------------------------------- You are done. Good luck and have fun! Wolfgang Wolfgang, I checked permissions on all files that are related to mysql to allow anyone to do anything. Mysql boot without a hitch. Thanks a lot. I guess I am still going to have to figure out how to bring mysql up as a normal user. Thanks again, Dave At 10:42 AM 1/30/01 +0100, you wrote: >Don't reinstall! > >The problem can be solved very easily. The error-message informs you, that >the mysql-user can not access a certain file. Give this file to the >mysql-user. (I mean, do: "chmod mysql.mysql /tmp/mysql.sock", assumed that >the mysql-user is named "mysql", that he is member of the group "mysql" and >that the file, that could not be accessed is "/tmp/mysql.sock") > >Wolfgang Arendt > >Vodafone TeleCommerce GmbH >SW Test & Config. Management >Wolfgang Arendt >Daniel-Goldbach-Str. 17-19 >40880 Ratingen > >Tel. +49 (0) 21 02 / 97 2492 >Fax +49 (0) 21 02 / 97 2453 > >mailto:[EMAIL PROTECTED] >www.vodafone-telecommerce.de > > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Gesendet am: Montag, 29. Januar 2001 21:29 > An: [EMAIL PROTECTED] > Betreff: Can't start server : Bind on unix socket: Permission >denied > > I am trying to bring up my third mysql server. This one is > MySQL-3.23.32-1.i386.rpm..rpm on a redhat 6.2 base. I was >successful in > installing both the server and the host. Look around and every >thing > looked cool! Piece of Cake! Then I decided to set up the >mysqladmin user > and setup privelidges, etc. The other two servers are run as root >with no > security. Every thing has gone down hill. All I get is this > message: 'Can't start server : Bind on unix socket: Permission >denied' > whenever I try to start mysql. I've even rebooted the unix a few >times, > rebuilt the initial data base, etc. Tried every command I could >find in > the doc, but it won't budge. Only trying to get mysql to startup as >root. > > I am about ready to start from scratch ... but reformat the drives >and > re-installing redhat seems too drastic. > > Please help. > > > The hardware is IBM 6000R Netfinity with 1.5 g memory, dual 700 mh >pentium > processors, 200 g scsi raid set up as 1E. > > > >--------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: >http://lists.mysql.com/php/unsubscribe.php > > > > ----------------------------------------------------------- > This Mail has been checked for Viruses > Attention: Encrypted Mails can NOT be checked ! > > *** > > Diese Mail wurde auf Viren ueberprueft > Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! > ------------------------------------------------------------ > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
