Mysql installation problem

vineeth.vvv · 02-26-2012, 10:26 PM

i started studying mysql and when i am about to install it in my ubuntu os the reply is
" sudo: aptitude: command not found "... anyone can help me... I am getting this problem for the last few days...

rhklinux · 02-26-2012, 11:43 PM

type this in terminal.You will be asked for new root password for mysql

Quote:

sudo apt-get install mysql-server-5.1

after installation type mysql -uroot -p and enter password you have set during installation.
Welcome to LQ !!

Satyaveer Arya · 02-27-2012, 05:53 AM

Try this:

Open a terminal window, and use the following command:

Code:

# sudo apt-get install mysql-server

During the installation process you will be prompted to enter a password for the MySQL root user.

Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running:

Code:

# sudo netstat -tap | grep mysql

When you run this command, you should see the following line or something similar:

Quote:

tcp 0 0 localhost:mysql *:* LISTEN 2556/mysqld

If the server is not running correctly, you can type the following command to start it:

Code:

# sudo /etc/init.d/mysql restart

If you are running PHP you will also need to install the php module for mysql 5:

Code:

# sudo apt-get install php5-mysql

To create a new database, use the mysqladmin command:

Code:

# mysqladmin create <databasename>