On Mon, 27 Jan 2003 03:52:57 +0000, rasshadrockuhuru
>On Sat, 18 Jan 2003 05:31:25 +0000, rasshadrockuhuru
>>>On Thu, 16 Jan 2003 22:38:15 +0000, rasshadrockuhuru
>>>>having trouble with mysql
>>>>i can only start the server as root
>>>>when i use adduser interactivly to create mysql
>>>>i use /usr/bin/false as the shell
>>>>but i am not sure about the password
>>>>or if i need a home directory for the mysql user
>>>>what adduser command do i use to
>>>>create an unprivilidge user (mysql)
>>>>for the mysql server to run as.
>>>I run the server under what I consider the mysql administrator
>>>(mysqladm). I *do* allow logins and I *do* set up a home directory
>>>for him. Any backups are also done by him and are stored under
>>>/home/mysql. Obviously you must accord him the rights to interact
>>>with the database. He gets all rights except GRANT.
>>got him up and running
>mysql user details :-
>mysql installed from port tree
>mysqld startup command line :-
> /usr/local/bin/safe_mysqld -user=mysql -log &
>using the above commandline, mysql fails to start
>the log says that mysqld cannot change to user mysql
>do i need to grant database rights to mysql before you can run mysqld
>as mysql ?
>am i the only one whith this problem, can't find anything in the mail
You need to ensure ownership and permissions for the mysql related
directories and files are set for this user.
Including that issue and more, here are some of my notes. Notice how
I set up my user during the build phase:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysqladm
useradd -c "MySQL user" -g mysqlgrp mysqladm
chown -R root:mysqlgrp /usr/local/mysql
chown -R mysqladm /usr/local/mysql/var
edit the PATH for the MySQL user: append /usr/local/mysql/bin
bin/mysqladmin -u root password "$ROOTPASS"
bin/mysql -u root -p mysql