Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 10-14-2002, 02:56 PM   #1
Registered: Feb 2002
Posts: 586

Rep: Reputation: 30
MySQL and Linux(RH7.3) start


Yestarday I started to learn MySQL database. I downloaded the file from ( MySQL-3.23.52-1.i386.rpm) installed
[root@localhost local]# rpm -qa | grep MySQL

Also, as I understand the MySQL daemon is running:

[root@localhost mysql]# ps -aux | grep mysql
mysql 5023 0.0 0.3 10576 1008 pts/2 S 15:43 0:00 /usr/sbin/mysqld
mysql 5025 0.0 0.3 10576 1008 pts/2 S 15:43 0:00 /usr/sbin/mysqld
mysql 5026 0.0 0.3 10576 1008 pts/2 S 15:43 0:00 /usr/sbin/mysqld
root 5071 0.0 0.2 1760 588 pts/2 R 15:49 0:00 grep mysql
[root@localhost mysql]#

My Question is why command like "show databases"; // doesn't work ?
or "USE mysql;" //doesnt' wor. In other words, almost all command doesn't work. Therefore, I think something wrong.

And How can I stop, start and restart MySQL.

[root@localhost mysql]# whereis mysql
mysql: /usr/lib/mysql /usr/share/mysql

Where is mysql database is ?

Last Question: I read book "MySQL in 21 days" by Mark Maslakowski
And in this book he install MySQL in mysql-3.22.23b-pc-linux-gnu-i686.tar.gz (tar.gz) format and I did in "rpm" format. Mark Maslakowski mentions that directory mysql should containt these files:

ChangeLog bin lib mysql-for-dummies
INSTALL-BINARY configure manual.htm scripts
PUBLIC data manual.txt share
README include manual_toc.html sql-bench
Support-files tests

However, no such files in the directory. Is it normal ?

Old 10-14-2002, 09:05 PM   #2
LQ Newbie
Registered: Jul 2002
Posts: 10

Rep: Reputation: 0
Can you login to the MySQL database? At a command prompt type:

mysql -u root

This should give you a "mysql>" prompt where you can issue the commands you listed.

Be careful if the the machine is connected to the internet, the MySQL database is "wide-open" by default.



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
how to start mysql on redhat enterprise linux 3 lifeform Linux - Software 15 05-03-2004 09:09 AM
start X on RH7.3 doesn't work! Alwus Linux - Newbie 6 09-28-2002 03:17 PM
'start X' on RH7.3 txt kernel doesn't work! Alwus Linux - Distributions 2 09-27-2002 01:49 AM
MySQL from RH7.3 RPM's: who did this? PJHAMVS Linux - Software 2 09-22-2002 05:53 AM
MySQL Problem in RH7.1 breakfree Linux - Newbie 0 08-22-2001 10:50 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:16 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration