Download and install MySQL in Linux

From AlfrescoWiki

[edit] Ubuntu - Breezy

you can get it by using the apt-get install (if you use Debian or Ubuntu) command or by downloading the tar.gz file and running the install. I also installed mysql-admin on my pc for a nice gui. This is not the best but its a gui.. :-)

The apt-get command:

sudo apt-get install mysql-server-4.1

sudo apt-get install mysql-admin

After installing mysql you need to configure it. (During the installation ou might be asked to configure postfix. I just chose no config).

The easyest to configure is to log in as root (or using sudo -su if sudoer)

type mysql

you get normaly the sql prompt (mysql> )

There you type connect mysql, this will connect you to the mysql database who holds the privileges.

her you can add user like

GRANT ALL PRIVILEGES ON *.* TO 'luc'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'luc'@'%' IDENTIFIED BY 'your-password' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';

GRANT USAGE ON *.* TO 'guest'@'localhost';

in short what you see on the screen:

luc@lenin:~$ sudo apt-get install mysql-server4.1
[The installation text   maybe postfix config request, you'll see..]

luc@lenin:~$ sudo apt-get install mysql-admin
[The installation text..]

luc@lenin:~$sudo -su
root@lenin:/home/luc# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.1.12-Debian_1ubuntu3-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> connect mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    12
Current database: mysql

mysql> GRANT ALL PRIVILEGES ON *.* TO 'luc'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'luc'@'%' IDENTIFIED BY 'your-password' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT USAGE ON *.* TO 'guest'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
root@lenin:/home/luc# exit
luc@lenin:~$mysql-admin

for more info about users, look at http://dev.mysql.com/doc/refman/4.1/en/adding-users.html

---

Previous - Top - Next

--Ayyapan 15:02, 17 May 2006 (BST)