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.

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.

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

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?

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.

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.

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?

Hmm. Is it possible to install a new version of debian on this system?

only with my root acces?

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.

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 .

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?

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...

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.

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?