MySQL Port Question
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@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL Port Question
On 1/10/07, Stan Halprin [EMAIL PROTECTED] 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 # echo 'mysql_enable=YES' /etc/rc.conf # /usr/local/etc/rc.d/mysql-server start ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL Port Question
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 [EMAIL PROTECTED] 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@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] -- George Vanev Information Systems Specialist tel.: +359 898 44 25 37 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL Port Question
- Original Message From: George Vanev [EMAIL PROTECTED] From: Andrew Patyukhin Andrew: /usr/local/etc/rc.d/mysql-server start Worked. MySQL up! Thanks! George: Since MySQL is up, I don't know if the following matters any more, nonetheless... Check if user mysql exists. If it doesn't - create it. Exists # echo 'mysql_enable=YES' /etc/rc.conf ok. #cd /usr/local/mysql #bin/mysql_install_db --user=mysql # cd /usr/local/mysql /usr/local/mysql: No such file or directory. # mkdir -p /usr/local/mysql # cd /usr/local/mysql # bin/mysql_install_db --user=mysql BTW, do I want to use the same user mysql? I'm wondering if that's a user that the installation itself uses. Should I set up another user? # bin/mysql_install_db --user=mysql bin/mysql_install_db: Command not found. # find / -name mysql /usr/bin/mysql /usr/local/bin/mysql /usr/local/include/mysql /usr/local/lib/mysql /usr/local/libdata/ldconfig/mysql /usr/local/share/mysql /usr/local/mysql /var/db/mysql /var/mail/mysql # ls /var/db/mysql/ # TIA, Stan __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql port question
Hi, I am planning to install mysql on a FreeBSD 5 system but I am confused a little bit. I had some problem while I had installed mysql on FreeBSD4. I know there were problems on FreeBSD 4 (in fact thread implementation of FreeBSD) with mysql. On FreeBSD mysql40-server port I have seen an option like: WITH_PROC_SCOPE_PTH I want to use kernel threading with system scope. As far as I understand for that I have to enable system scoped threading sysctl knob and compile mysql without WITH_PROC_SCOPE_PTH=1 to take advantage of FreeBSD 5 threading model . Am I right? Best Regards. --- Omer Faruk Sen http://www.EnderUNIX.ORG Software Development Team @ Turkey http://www.Faruk.NET For Public key: http://www.enderunix.org/ofsen/ofsen.asc First Turkish FreeBSD book is out! Go check it. Duydunuz mu! Turkiye'nin ilk FreeBSD kitabi cikti. http://www.acikkod.com/freebsd.php ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
