LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 10-30-2003, 07:48 AM   #1
shycalais
Member
 
Registered: Sep 2003
Distribution: rh
Posts: 43

Rep: Reputation: 15
mySQL install from RPM (where is it??)


hi!
linux really isn't ready for mainstream! i've downloaded mySQL binary and unzipped it and nothing worked, so i read the documentation which said they strongly recommend the RPM installation of mySQL. so i downloaded the client and server RPM and installed with the command:
rpm -i MySQL-server-4.0.16-0.i386.rpm MySQL-client-4.0.16-0.i386.rpm

so where is it?
it says in the documentation it creates a directory in /etc/lib/mysql so i go there and very few files are there, no /scripts/ or anything..

i'm pretty new to linux (few months) and haven't used mySQL before, so if i missed out on anything (spinning 3 times clockwise before hitting enter) or something similar it's not telling me in the doc's..

i tried to install the rpm's again and it says their already installed!

i'm running Redhat9.0

any help would be much appreciated!
 
Old 10-30-2003, 08:29 AM   #2
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
You might want to try the find command to find where the scripts are. Something like find / mysql_install_db. See man find for more options.


Quote:
linux really isn't ready for mainstream!
Maybe its just me, but it seems kinda silly to condemn the whole OS because your having difficulty with one program.
 
Old 10-30-2003, 06:26 PM   #3
shycalais
Member
 
Registered: Sep 2003
Distribution: rh
Posts: 43

Original Poster
Rep: Reputation: 15
thanks! i still can't find it!
searched everything.. its not there!

why could it just install to one easy and convienent place!

has anyone else got any suggestions? really stuck!
 
Old 10-30-2003, 07:18 PM   #4
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
OK, unless the rpm installation failed (and you would have seen error message) it has to be there. Post the results of find / -name mysql* and be sure to run it as su or root to make sure you have permissions for all directories. You also might take a look around /usr/local since that is where the source version ends up.

Last edited by Hangdog42; 10-30-2003 at 07:19 PM.
 
Old 10-30-2003, 08:35 PM   #5
shycalais
Member
 
Registered: Sep 2003
Distribution: rh
Posts: 43

Original Poster
Rep: Reputation: 15
i'm getting no errors! this is what it comes up with!

warning: MySQL-server-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Installing all prepared tables
031031 12:31:37 /usr/sbin/mysqld: Shutdown Complete


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Starting mysqld daemon with databases from /var/lib/mysql

so i've set passwords and stuff! but in docs it tells me to go into /scripts/ and it just doesn't exist! has anyone installed this? if so can i have some pointers?

i'm just trying to make a webpage, and need SQL to test a program! if i can't get it working then my webpage idea is dead unless i want to pay a lot of money for a webaddress just to write the program (which isn't feasiable)
 
Old 10-30-2003, 08:53 PM   #6
shycalais
Member
 
Registered: Sep 2003
Distribution: rh
Posts: 43

Original Poster
Rep: Reputation: 15
so i change to /usr/bin/ and run .mysql_install_db which is supposed to ??create?? a ./scripts dir, but it just doesn't!!! WHY?
 
Old 10-30-2003, 08:53 PM   #7
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
You know, its possible that the script is run as part of the rpm install. Start up mysqld and log in. Then at the mysql prompt enter show databases;. If you see the mysql database, you're probabaly set. You can make sure by checking the tables in mysql, and if you see the appropriate tables, you're good to go. The fact that mysqladmin isn't complaining when setting root's password suggests that the mysql database exists and has the proper tables.
 
Old 10-30-2003, 08:53 PM   #8
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
You know, its possible that the script is run as part of the rpm install. Start up mysqld and log in. Then at the mysql prompt enter show databases;. If you see the mysql database, you're probabaly set. You can make sure by checking the tables in mysql, and if you see the appropriate tables, you're good to go. The fact that mysqladmin isn't complaining when setting passwords suggests that the mysql database exists and has the proper tables.
 
Old 10-30-2003, 08:56 PM   #9
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
Quote:
so i change to /usr/bin/ and run .mysql_install_db which is supposed to ??create?? a ./scripts dir, but it just doesn't!!! WHY?
No, thats not what mysql_install_db does. That script sets up the initial mysql database and the tables that it needs to hold users, passwords and privileges. It will NOT create any directories.
 
  


Reply


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
MySQL mysql-3.23.56-1.9, rpm install problem jacsmith510 Linux - Newbie 3 09-19-2003 03:02 PM
Mysql rpm re-install question. BGuarnieri Linux - Software 9 07-15-2003 08:19 PM
mysql rpm install: Didn't find /usr/libexec/mysqld rioguia Linux - Software 2 01-27-2003 09:56 AM
RPM install for MySQL needamiracle Linux - Software 3 07-09-2002 04:30 PM
Help Me. I am trying to install MySql-3.23.42 rpm 3MTA3 Linux - Software 7 09-19-2001 08:49 PM


All times are GMT -5. The time now is 05:54 AM.

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