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
