Download and install MySQL in Linux

Document created by resplin Employee on Jun 6, 2015
Version 1Show Document
  • View in full screen mode

Obsolete Pages{{Obsolete}}

The official documentation is at: http://docs.alfresco.com



Installation


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)

Attachments

    Outcomes