Place to share anything

Free Software, Download, Tips and Tutorials, Cars, Notebook, Review

How to install and configure the latest MySQL Server on Ubuntu in easy way

MySQL is the most popular SQL database server. This tutorial will show you how to install MySQL server in Ubuntu with just few steps.

Okay, lets start

1. First open terminal and paste the following command.

 apt-get install mysql-server mysql-client libmysqlclient12-dev

2. By default, MySQL only receive local connections / from localhost (127.0.0.1). Now we need to edit this setting so we can connect to our MySQL from anywhere. Edit the MySQL configuration file located in /etc/mysql/my.cnf. You can use your favorite editor to do this. I use gedit in this case.

 sudo gedit /etc/mysql/my.cnf

3. Find the line bind-address = 127.0.0.1 and comment it out.

#bind-address = 127.0.0.1

4. Close and save the file. Now check your configuration using this command

netstat -tap

Output Looks like below

tcp 0 0 *:mysql *:* LISTEN 4997/mysqld

5. By default, MySQL comes without any root password. For more safety, you need to set one.

#mysqladmin -u root password your-new-password
#mysqladmin -h root@local-machine-name -u root -p password your-new-password
#/etc/init.d/mysql restart

Okay, that’s it enjoy.

Source article

Incoming search terms for the article:

  • Share/Bookmark

How to install Cairo Dock in Debian Lenny

Cairo Dock is a light eye-candy fully themable animated dock for any Linux desktop. It has a family-likeness with OSX dock, but with more options. This application will place many shortcut of your installed software so it will be easy to access. This tutorial will show you how to install Cairo Dock in Debian Lenny system.

1. First you need to edit the /etc/apt/sources.list and add the Cairo Dock repository line. You can use vi or gedit. In my case I use gedit to edit the sources.list

sudo gedit /etc/apt/sources.list

and add the following line:

deb http://repository.cairo-dock.org/debian stable cairo-dock

Then save and exit.

2. Now install the GPG key using this command

#wget -q http://repository.cairo-dock.org/cairo-dock.gpg -O- | apt-key add -

3. Then update your system.

sudo apt-get update

4. Finally install the Cairo Dock using single command below

#apt-get install cairo-dock cairo-dock-plug-ins

5. Now you can run cairo-dock from Applications —> System tools—> cairo-Dock

Technorati Tags: ,,,,,,,,,,,,

Incoming search terms for the article:

  • Share/Bookmark

Install OpenOffice 3.1.0 on Debian Lenny using Debian Lenny Backports

By default, debian Lenny include OpenOffice 2.6.4 and this is a little bit old since the new OpenOffice 3.1 was released. But, we can easily install or update the OpenOffice 2.64 into current OpenOffice 3.1.0 by activating or using Debian Lenny Backports. To get started, please follow the tutorial below:

1. Add the backports repositories
To add the Lenny backports repositories, simply edit as root your /etc/apt/sources.list file and add the following line:

 deb http://www.backports.org/debian lenny-backports main contrib non-free

Then close and make sure you save the file.

2. Install the Debian backports keyring

Open terminal and execute this command as root:

apt-get install debian-backports-keyring

3. Update your repositories

apt-get update

And install OpenOffice.org:

apt-get -t lenny-backports install openoffice.org

4. Now enjoy the new version of OpenOffice 3.1.0 on your Debian Lenny

Incoming search terms for the article:

  • Share/Bookmark