google eventually returned the syntax I needed,
[root@ovirt1 bacula]# /usr/libexec/bacula/grant_mysql_privileges -u root -p
Enter password:
8><-----
Privileges for user bacula granted on database bacula.
[root@ovirt1 bacula]# /usr/libexec/bacula/make_mysql_tables -u bacula -p
Enter password:
Creation of Bacula MySQL tables succeeded.
[root@ovirt1 bacula]#
On 3 November 2016 at 11:31, Thing <thing.th...@gmail.com> wrote:
> I already tried that,
>
> [root@ovirt1 bacula]# ./create_mysql_database
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> Creation of bacula database failed.
> [root@ovirt1 bacula]#
>
>
>
> On 3 November 2016 at 11:03, Mike Ruskai <than...@earthlink.net> wrote:
>
>> make_mysql_tables is a shell script, not just a set of SQL statements.
>>
>> Run it by itself, providing whatever options you need to connect to and
>> authenticate with the correct MySQL instance.
>>
>> In your case, it looks like you just need to get rid of "mysql <" on your
>> command line.
>>
>>
>> On 11/2/2016 17:52, Thing wrote:
>>
>> I went into the mysql and dropped the bacula database.
>>
>> However I am having problems trying to re-create the database/tables,
>>
>>
>> ============
>> [root@ovirt1 bacula]# mysql < make_mysql_tables -p
>> Enter password:
>> ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check
>> the manual that corresponds to your MariaDB server version for the right
>> syntax to use near 'bindir=/usr/bin
>> PATH="$bindir:$PATH"
>> db_name=${db_name:-bacula}
>>
>> if mysql -D ${d' at line 1
>> [root@ovirt1 bacula]# mysql < create_mysql_database -p
>> Enter password:
>> ERROR 1064 (42000) at line 6: You have an error in your SQL syntax; check
>> the manual that corresponds to your MariaDB server version for the right
>> syntax to use near 'bindir=/usr/bin
>> db_name=bacula
>>
>> if $bindir/mysql $* -f <<END-OF-DATA
>> CREATE DATA' at line 1
>> [root@ovirt1 bacula]#
>> =========
>>
>> ?
>>
>> On 3 November 2016 at 10:35, Thing <thing.th...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I have bacula running on centos7.2 using mysql.
>>>
>>> What do I do to delete the test backups and start fresh?
>>>
>>> This must rate being a FAQ? however I find little via google on how to
>>> do this (that worked).
>>>
>>> thanks
>>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Developer Access Program for Intel Xeon Phi Processors
>> Access to Intel Xeon Phi processor-based developer platforms.
>> With one year of Intel Parallel Studio XE.
>> Training and support from Colfax.
>> Order your platform today. http://sdm.link/xeonphi
>>
>>
>>
>> _______________________________________________
>> Bacula-users mailing
>> listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Developer Access Program for Intel Xeon Phi Processors
>> Access to Intel Xeon Phi processor-based developer platforms.
>> With one year of Intel Parallel Studio XE.
>> Training and support from Colfax.
>> Order your platform today. http://sdm.link/xeonphi
>> _______________________________________________
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
