MySQL Install Issue

Beri, Rohit linuxlist at beris.net
Wed Jan 19 06:58:58 UTC 2005


Thanks tony for that word of advice.

Thanks,

-B
Tony Dietrich wrote:

>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!)
>
>  
>




More information about the users mailing list