MySQL installation errors

B

balanga

I have only just installed FreeBSD (latest stable release) and am trying to set up a hosting server using Wordpress. The prerequisites are (L)AMP.

Apache seems to have been successfully installed, as does PHP, both using ports, but I'm stuck trying to get the MySQL server working. I have followed various links but it seems they are out of date. I tried using ports but that didn't work so did a deinstall and tried using pkg install mysql56-server.

What do I need to do to get it working?

Running /usr/local/etc/rc.d/mysql-server start results in:
Code: 
WARNING: failed precmd routine for mysql

Any help would be appreciated.
 
Incompatible cruft from a prior install perhaps? The install/start works for me on a clean system. If you haven't actually used it yet, try to rm -r /var/db/mysql and start again to let it create a fresh database.

Also, the supported default MySQL version is 5.5 right now. Some software may have a dependency on that version and give you hassles trying to use 5.6. If you want to use the publicly supported packages from the project you'll have an easier time using 5.5.
 
Hi there,

Install the mysql-server package of your choice, and then just run:
/usr/local/libexec/mysqld --initialize

After that, just start your MySQL service; don't forget to add it to the rc.conf.

Cheers.
 
Carlos Trentini said:
Hi there,
Click to expand...
Please look at the date of the thread before responding, this thread is almost 2 years old.

Install the mysql-server package of your choice, and then just run:
/usr/local/libexec/mysqld --initialize
Click to expand...
This is not needed and may even cause problems. Simply start the service: service mysql-server start. If the databases need to be initialized (because it's the first time you start it) it will be done automatically by the rc(8) scripts.
 
You must log in or register to reply here.
Back
Top