PDA

View Full Version : [ubuntu] Help me about install MySQL SERVER



zoran035
June 2nd, 2009, 04:56 PM
This is my frst in OS ubuntu. I want to install MySQL and tools for manipulatig databases in server. Help me

Celauran
June 2nd, 2009, 05:02 PM
sudo aptitude install mysql-server

zoran035
June 2nd, 2009, 05:15 PM
Thanks a lot Celauran, my English not so good, Zoran

zoran035
June 2nd, 2009, 05:23 PM
Next question, name of server, where is it, how to open in 'emma' ,... MySQL is my first too, but I have expiriance with SQL SERVER 2005 Thanks again

Celauran
June 2nd, 2009, 05:32 PM
I'm not sure what 'emma' is, so I can't help you there. You can use localhost as the server name.

cariboo
June 2nd, 2009, 05:33 PM
The name of the server is what you named it during installation, to find the name at the prompt type:


hostname

I would suggest you install phpmyadmin to administrate mysql, as there is no gui installed. PnpMyadmin is in the repositories. It might ber a good idea to install the mysql documentation which is also in the repositories.

zoran035
June 2nd, 2009, 06:23 PM
Once again, Thanks a lot Celauran, forgot 'emma' , I found another manager MYSQL Administrator, and I create my first database and firs table and first sproc.
My INSTANCE conn = ( User=root, Host = localhst, Socked = /var/run/mysqld.sock )
My SERVER INFORMATION = ( Network Name = localhst, IP = 127.0.0.1 )
My CLIENT INFORMATION = ( Network Name = ububtu , IP = 127.0.1.1 , OS = Linux 2.6.28-11-generic )
I am VB6 + SQL Express 2oo5 in WIN and want to use Gambas in Linux with MySQL. Is it good idea ?

zoran035
June 2nd, 2009, 06:42 PM
Ops!!! Cariboo907 Thanks . I did not see another nik