Re: [cobalt-users] mySQL & PHP after the install question...

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

Barnabas Toth <barnabas@xxxxxxxxxxxxxxxxxxxxx> wrote:
> So I started up the mysqld daemon with databases from /var/lib/mysql. But my
> question now is does this have to done every time the server reboots? Is
> their a way of having this start automatically?

Yes.  If you installed from source copy the mysql.server script found in the source
distribution into /etc/rc.d/init.d/mysql and then add this line to
/etc/rc.d/rc.local:
/etc/rc.d/init.d/mysql start
Or don't use the script and instead add this line to the same file (editing to
correct file locations):
/usr/local/mysql/libexec/mysqld --log=/var/log/mysql_log --log-update=/var/log/mysql_
log_update
These aren't the only solutions, but they work.

> Does mySQL have a GUI/Web interface of any kind? If it does where can I
> access it at (Url)?

Not built in.  There are a number of MySQL clients for Windows and Linux and at least
several web-based PHP front-ends.  One is called PHPMyAdmin and you can find a link
at http://php.net/projects.php.

> How do I see that mySQL is actually running and working? Is there a test
> database that I can run to test it?

It should install with a test database called "test".  Run a query from the mysql
commandline.  Also from bash commandline, type "ps aux | grep mysql".  You should get
back some process including "mysqld".

> What about seeing if PHP is working? How would I go about that?

Create a file with one line:
<? phpinfo(); ?>
Then access it from the web.  If you get a few screens of output it worked.

> Also is their a script that I can run for PHP to see if it is working?

I answered that above.

> Thanks for all your help in advance.

Sure.  If you need more assistance let me know.

Steven Werby {steven-lists@xxxxxxxxxxxx}