Create Database
|
[root@dlp ~]#
vi /usr/lib64/bacula/grant_mysql_privileges
# line 9: change
if $bindir/mysql $* -u root
-p
<[root@dlp ~]#
vi /usr/lib64/bacula/create_mysql_database
# line 9: change
if $bindir/mysql $*
-p
<[root@dlp ~]#
vi /usr/lib64/bacula/make_mysql_tables
# line 7: change
if $bindir/mysql $*
-p
<[root@dlp ~]#
/usr/lib64/bacula/grant_mysql_privileges
Enter password: Privileges for bacula granted on bacula. [root@dlp ~]#
/usr/lib64/bacula/create_mysql_database
Enter password: Creation of bacula database succeeded. [root@dlp ~]#
/usr/lib64/bacula/make_mysql_tables
Enter password: Creation of Bacula MySQL tables succeeded. [root@dlp ~]#
mysql -u root -p
# login MySQL
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 50 Server version: 5.0.45 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
# set bacula's password
mysql>
set password for bacula=password('password');
Query OK, 0 rows affected (0.00 sec) mysql>
set password for bacula@localhost=password('password');
Query OK, 0 rows affected (0.00 sec)
# verify settings
mysql>
select user,host,password from mysql.user;
mysql>
show databases;
mysql>
use bacula;
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql>
show tables;
mysql>
exit
Bye |