I have installed mysql form the rpm files that are on rpm finder, acording to the installation it is working, and if I check with redhat-config-services it is running, how do I get mysql on the path so I can call mysql from any where?
There are a few ways to do that.
I've got a SuSE Linux so we might differ a bit but in general you have to extend the PATH environment variable for your db-admin user or for all users.
For all users in /etc/profile or if in /etc/profile.local if /etc/profile calls it like SuSE's does. ------------------------------------------------ # /etc/profile.local PATH=$PATH:/usr/local/mysql/bin export PATH ------------------------------------------------
BUT FIRST you should find the right path.
I installed the binary from mysql.com which I placed at the location above. SuSE's installer stuffs the mysql files in /usr/bin so you probably look there first.
Or use the command "whereis mysql" which should give you the path.
Apart from /etc/profile there can be 2 config-files in the individual users home directory.
/home/alex/.profile and /home/alex/.bashrc
> where is mysql executable file?
--> whereis mysql
> I know the server is running but just beause I see it
running on redhat-config-services but I do not know where are the files.. acording to mysql manual there is a test database.. where?
If you make it in the mysql-interface you can enter "SHOW VARIABLES;". This dumps all kind of info and among it there is a line for "datadir". Thats the basedirectory for your database-files.
It should be /usr/local/mysql/data as in the mysql standard configuration. Or Redhat has put it somewhere else like SuSE. SuSE sets datadir to /var/lib/mysql for some reason thats beyond me.
For the first steps it's irrelevant where the data gets stored.
The point of a db-server is that one doesn't have to mind in which folder or drive the files reside. Let the db administrator handle this. (OK, that might be you ;) )
You enter a database with the mysql command "use". The test database is called "test". So you connect to it with "use test" on mysql's command line.
You should install a mysql GUI. E.g. phpMyAdmin. It helps a bit not having to remember all commands.
btw ... mysql has a documentation that helps a lot.
You should look on their web-site for the version with "on page per chapter". The one-REALLY-big-chunk-of-html-version that comes with the distribution is hard to handle for most computers.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
