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)
