LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-28-2002, 12:54 PM   #1
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Rep: Reputation: 15
Installing MySQL via shell


Hi.

I'm just new to linux and I wanted to know:

Is it possible, to install a MySQL server from an Windows (XP)Machichine on a Linux Machine via Shell or Telnet or sometin like that?

If yes, how? Can anybody post me a tutorial how to?

thx Luc.
 
Old 10-28-2002, 01:14 PM   #2
txGeek
Member
 
Registered: Oct 2002
Location: Houston, TX
Distribution: Debian, Redhat
Posts: 39

Rep: Reputation: 15
Which Linux distribution are you using? Several (Debian, Gentoo, Redhat, etc.) have prebuilt packages that can be installed with emerge or apt-get. The install and the post-install configuration can be done from the command line.

For the installation procedures check your distribution to see if a prebuilt package is available first. If not consult the documentation at http://www.mysql.com/documentation/index.html fir detailed installation and post-installation procedures.
 
Old 10-30-2002, 03:33 AM   #3
doublefailure
Member
 
Registered: Mar 2002
Location: ma
Distribution: slackware
Posts: 747

Rep: Reputation: 30
why not,
if linux machine has telnet or ssh,
u can surely install mysql on the machine
 
Old 10-30-2002, 09:38 AM   #4
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
Quote:
Originally posted by doublefailure
why not,
if linux machine has telnet or ssh,
u can surely install mysql on the machine
I never would do anything over telnet! Installing MySQL you need root rights for at least the last step and if you want to do something alike over an insecure protocol as telnet, have fun with those password sniffing people around ... might sound a bit paranoid but I don't even think of SSH as THAT secure, I have a very STRICT list of static ip adresses which have access to SSH (no root logins permitted, etc).
 
Old 10-30-2002, 02:08 PM   #5
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Original Poster
Rep: Reputation: 15
Sorry, but ssh, is the only way wich was offerd to me, to administrate my server. im totaly new to linux. i think my server runs with debian but im not shure.

Someone here who wants to install it for me?
 
Old 10-30-2002, 02:31 PM   #6
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,568

Rep: Reputation: 164Reputation: 164
It's quite easy. You can do this yourself. When you're logged via ssh you're working with the system in the same way when you connect a monitor and a keyboard to it.
The method to use depends on the distro the server's running. You can always install it form source, but that's harder. Packages are much easier to install.
 
Old 10-30-2002, 02:39 PM   #7
txGeek
Member
 
Registered: Oct 2002
Location: Houston, TX
Distribution: Debian, Redhat
Posts: 39

Rep: Reputation: 15
Quote:
Originally posted by Luc
Sorry, but ssh, is the only way wich was offerd to me, to administrate my server. im totaly new to linux. i think my server runs with debian but im not shure.

Someone here who wants to install it for me?
Well, since you are using Debian, do the following.

1. Shell into the machine.
2. Enter the following commands:
apt-get update
apt-get install mysql-server mysql-client

3. Follow the instructions found in the MySql manual to setup your database, security, etc.
 
Old 10-30-2002, 02:47 PM   #8
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Original Poster
Rep: Reputation: 15
Ok.

apt-get update
apt-get install mysql-server mysql-client

Do I have the newest mysql version, then?
Should I first uninstall the version wich isnt working? How do I make this?

It was already installed a Version of MySQL.someone did delte it.(not me I didnt know whats shell just a few seconds before). And now I didnt know how to get this shit working again.

edit: Shit. Its not Debian. Its suse linux.
How can I instell debian?

Last edited by Luc; 10-30-2002 at 02:49 PM.
 
Old 10-30-2002, 03:06 PM   #9
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Original Poster
Rep: Reputation: 15
Hmm. Is it possible to install a new version of debian on this system?

only with my root acces?
 
Old 10-30-2002, 03:07 PM   #10
txGeek
Member
 
Registered: Oct 2002
Location: Houston, TX
Distribution: Debian, Redhat
Posts: 39

Rep: Reputation: 15
If you are running Suse you should be able to uninstall and then reinstall MySql using YaST. I believe the commands are:
yast -u mysql-client
yast -u mysql
yast -i mysql
yast -i mysql-client


If you have a version of MySql that isn't working correctly you should try to fix the installation or remove it and reinstall using YaST. If you have any information in the database you should backup those files and any security information before removing MySql.

After installation you should be able to use mysqladmin to determin which version was installed.
 
Old 10-30-2002, 03:12 PM   #11
txGeek
Member
 
Registered: Oct 2002
Location: Houston, TX
Distribution: Debian, Redhat
Posts: 39

Rep: Reputation: 15
Quote:
Originally posted by Luc
Hmm. Is it possible to install a new version of debian on this system?

only with my root acces?
You can install Debian, but that is a little like throwing the baby out with the bath-water.

If you really want to dump the SUSE install, visit http://www.debian.org/releases/stable/installmanual and follow the instructions for installing Debian 3.0. I have never installed Debian remotely, and I am not sure if it is even possible, so you may need console access to install Debian. A good installation walkthrough is available at http://www.osnews.com/story.php?news_id=2016 .
 
Old 10-30-2002, 04:04 PM   #12
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Original Poster
Rep: Reputation: 15
ok txGeek.

I have now uninstall the mysql packages with the graphical (yeah!) interface form yast.

Now I want to install the new package. Yast is now asking me for a 1) ftp-server or 2)cd-rom or 3)dir

how can I load a mysql package file to my server?
 
Old 10-30-2002, 04:22 PM   #13
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Original Poster
Rep: Reputation: 15
jea! I got it!

an how do i configurate my mysql server now?

the mysql command is not working.

what i get, if i try to use some scripts is: accec denied for user: root@localhost.

thx for your help till now...
 
Old 10-30-2002, 05:17 PM   #14
txGeek
Member
 
Registered: Oct 2002
Location: Houston, TX
Distribution: Debian, Redhat
Posts: 39

Rep: Reputation: 15
You shouldn't be administering MySql using root. You should create a userid to use for administering MySql, grant that userid DBO authority and login with that userid only when you need to manage the MySql server. Check the SUSE or MySql documentation to see what the default security settings are after the MySql install. Then you can use mysqladmin, Mascon/FreeMascon (http://www.scibit.com/Products/Softw...onFeatures.htm), or Webmin (install with YaST) to manage the security settings.
 
Old 10-31-2002, 03:24 AM   #15
Luc
Member
 
Registered: Oct 2002
Distribution: RedHat Linux 8.0
Posts: 37

Original Poster
Rep: Reputation: 15
I havent any documentation

If I want to reinstall all services. ftp and apache. Is it much work to set the settings of this two services? What is with the security. What is the best configuration for a mysql Server?
 
  


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
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 03:43 PM
MySQL in a shell script?! zaubara Programming 2 05-31-2004 06:27 PM
Installing MySQL.4.0.17 and php support for Mysql on RedHat 9.0 Neha Linux - Software 13 12-29-2003 01:06 AM
mysql via shell tommytomato Linux - General 8 12-01-2003 09:05 PM
mysql via shell help needed tommytomato Linux - Newbie 3 12-01-2003 01:03 PM


All times are GMT -5. The time now is 02:19 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration