MySQL Jumpstart

[Michael Baer]

>>>>> "John" == John Kebbel <kebbelj@scripting-solutions.com> writes:

    John> I chose to install MySQL when I installed YDL 3.0 from the
    John> CDs, but I couldn't seem to get it running. At first, I
    John> didn't think I had installed it, but when I checked the
    John> install log, there were two lines that read ...

    John> Installing mysql-3.23.54a-4.  Installing
    John> mysql-server-3.23.54a-4.

I believe what your seeing is that the mysql 'service' doesn't start
by default. There are a couple of GUI service editors that will allow
you to have mysqld start automatically, redhat-config-services (run as
root) I think is the current popular one. 

As a simple test though, or if you just want to run the server by hand
and you don't need it to start automatically at boot time, you can run
it's startup script with the command '/etc/rc.d/init.d/mysql start'
run as the root user. There is also a 'stop' and a 'restart' parameter
for the script.

To see if mysqld is currently running, the command, 'ps auxww | grep
mysqld' should give you an output with a line containing something
like '/usr/libexec/mysqld' in it.

e.g. 
mysql     3759  0.0  0.6 49440 3156 ?        S    Oct08   0:01 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking

Also, look at the installation instructions at the mysql website.
http://www.mysql.com/documentation/index.html

hope this helps
Mike

    John> I'm familiar with using MySQL commands (1) through a web
    John> page interface on the web server for my business and via (2)
    John> CGIs using the PERL DBI, but I've never actually had MySQL
    John> running from a command line on my own machine before. I'm
    John> not sure how to get it started or what it will look like
    John> when it's running. I get this message when I try mysql as a
    John> command...

    John> [kebbelj@localhost kebbelj]$ mysql ERROR 2002: Can't connect
    John> to local MySQL server through socket
    John> '/var/lib/mysql/mysql.sock' (111)

    John> When I try safe_mysqld, I get ...

    John> [kebbelj@localhost kebbelj]$ sudo safe_mysqld Starting
    John> mysqld daemon with databases from /var/lib/mysql 031028
    John> 17:27:47 mysqld ended

    John> I would greatly appreciate a jump start from someone on
    John> MySQL.



    John> _______________________________________________
    John> yellowdog-general mailing list
    John> yellowdog-general@lists.terrasoftsolutions.com
    John> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general


-- 
ydl@mikesoffice.com