MySQL Port Question

[George Vanev]

Check if user mysql exists. If it doesn't - create it.
# echo 'mysql_enable="YES"' >> /etc/rc.conf
#cd /usr/local/mysql
#bin/mysql_install_db --user=mysql
#chown -R root .
#chown -R mysql var
#chgrp -R mysql .
#bin/mysqld_safe --user=mysql &
#bin/mysqladmin -u root password ''
#bin/mysql
 grant all privileges on *.* to 'your_user'@'host' identified by 'password'
with grant option;
 exit;


On 1/10/07, Stan Halprin <stanhalprin at yahoo.com> wrote:
>
> Hello;
> I'm trying to build MySQL 5.0 (server) on FBSD 6.1 from port. I ran "make
> install clean" but now I'm lost. mysqld is not up. What is my username?
> Never asked me for one in the install. Tried this:
>
> # /usr/local/libexec/mysqld -umysql
> 070109 16:39:30  InnoDB: Operating system error number 13 in a file
> operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
> InnoDB: File name ./ibdata1
> InnoDB: File operation call: 'create'.
> InnoDB: Cannot continue operation.
>
> Looks like there's probably more that needs to be done to get an
> out-of-the-box MySQL port installation working. Please advise.
> Stan
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "
> freebsd-questions-unsubscribe at freebsd.org"
>



-- 
George Vanev
Information Systems Specialist

tel.: +359 898 44 25 37