Hi all,
Please help on following as it is doing my head in!.
I am writing a script that will allow creation of databases + users for them. Below is the "query" being executed, and the outcome from the mysql.die
"GRANT all privileges ON webbhost_testdb.* TO `webbhost@localhost` IDENTIFIED BY '********'"
ERROR: Could not connect (): Unknown database 'testdb'
I really cannot get my head around this, as it clearly states "webbhost_testdb" and not "testdb".
Can someone please tell my why this is happening?
P.S. Yes I am using "root" access to process this.
Please help on following as it is doing my head in!.
I am writing a script that will allow creation of databases + users for them. Below is the "query" being executed, and the outcome from the mysql.die
"GRANT all privileges ON webbhost_testdb.* TO `webbhost@localhost` IDENTIFIED BY '********'"
ERROR: Could not connect (): Unknown database 'testdb'
I really cannot get my head around this, as it clearly states "webbhost_testdb" and not "testdb".
Can someone please tell my why this is happening?
P.S. Yes I am using "root" access to process this.