Install
Requirements
You need this if you want to use the Project Session Mode. (see Pantera Operational Modes)
Installation Steps
MySQL Install
Thanks to Rick for the Linux install steps:
cd /usr ; /usr/bin/mysqld_safe &
run mysql_install_db
PLEASE
REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the
server, then issue the following commands:
/usr/bin/mysqladmin -u root
password 'new-password'
/usr/bin/mysqladmin -u root -h changeling password
'new-password'
:passw0rd!
First, use the mysql program to
connect to the server as the MySQL root
user:
shell> mysql
--user=root mysql
If you have assigned a password to the root account,
you'll also need to
supply a --password or -p option for this mysql command
and also for
those later in this section.
After connecting to the
server as root, you can add new accounts. The
following statements use GRANT
to set up four new accounts:
mysql> GRANT ALL PRIVILEGES ON *.* TO
'monty'@'localhost'
-> IDENTIFIED BY
'some_pass' WITH GRANT OPTION;
mysql has 2 default anonymous
accounts. to remove those:
Anonymous Account Removal
If you
prefer to remove the anonymous accounts instead, do so as
follows:
shell> mysql -u root
mysql> DELETE FROM mysql.user
WHERE User = '';
mysql> FLUSH PRIVILEGES;
2006 (C) http://www.roseslabs.com