MySQL Install Issue

[Tony Dietrich]

On Sunday 16 Jan 2005 08:05, Beri, Rohit wrote:
> Damn the 'd'.... thanks Miles... I had installed mysql-server package
> before just that I was using service mysql start...
>
> I got the db running now... how or which client should I use to get
> started quickly... this is my time with mysql db.
>
> Thanks,
>
> -B
>
> Miles Brennan wrote:
> >> so i finally went yum route, by installing yum install *mysql* and
> >> yum install *odbc* ... now everthing seems to have installed but in
> >> my KDE, i see no icons and there is no way i can start or stop
> >> services for mysql.
> >>
> >> service mysql start / stop returns unrecognized service....
> >
> > Sounds like you only have the command line client installed.
> >
> > Test with "rpm -q mysql-server"
> > Install with "yum install mysql-server"
> >
> > Then "service mysqld start" (there's a "d")
> >
> > Miles.
Rohit

System Settings >> Server Settings >> Services

Tick the box next to mysql in the list. Hit the toolbar 'Save' button. Hit the 
toolbar 'Start' button when the mysql line is highlighted.  Close the dialog 
box.
Now you have managed to both start the server, AND set it so that the server 
will start automatically on the next reboot.

Install Webmin.  Webmin has a mysql module that will allow you to setup, 
examine and configure mysql and the databases.  Another way of administering 
mysql easily is phpmysqladmin.  However, Webmin has much more to offer than 
just mysql admin.

Then, if you are planning on experimenting with linux much more, check out the 
man page for chkconfig.
That, combined with the 'service' command, will allow you command-line access 
to the same functions available from the GUI for services.

Read the manuals for mysql.  Most beginners stumble on host/database/user 
permissions first.  Always access any database through a user who has the 
minimum permissions neccessary to do the job.

One word of warning:
Don't play with the databades already installed by mysql.  Create your own to 
experiment.  The pre-installed database 'mysql' is a system database that 
holds user permissions, amongst other things.
(Does mysql still install the test database?  If so you can play with that!)

-- 
Tony Dietrich
-------------
Patch griefs with proverbs.
  -- William Shakespeare, "Much Ado About Nothing"