Problem mit "Adding new user"
am 28.06.2007 10:37:34 von Henk OegemaIch brauche Linux SuSE10.2 und versuche einen neuen 'user' zu zu fuegen in
den database.
Siehe beispiel:
http://asterisk2billing.org/html/x433.html
As root
mysql mysql
gibt mir:
************************************************************ **
asterisk:~ # mysql mysql
Welcome to the MySQL monitor. Â Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.26-Max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
************************************************************ **
SQL queries to create the new mysql user :
GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser2'@'%' IDENTIFIED
BY 'a2billing' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser2'@'localhost' IDENTIFIED
BY 'a2billing' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser2'@'localhost.localdomain'
IDENTIFIED BY 'a2billing' WITH GRANT OPTION;
\q (to quit)
gibt mir:
************************************************************ **********
mysql> GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser2'@'%' IDENTIFIED
BY 'a2billing' WITH GRANT OPTION;
Query OK, 0 rows affected (0.25 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'a2billinguser2'@'localhost'
IDENTIFIED BY 'a2billing' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.*
TO 'a2billinguser2'@'localhost.localdomain' IDENTIFIED BY 'a2billing' WITH
GRANT OPTION Â Â Â ;
Query OK, 0 rows affected (0.00 sec)
mysql> \q
Bye
************************************************************ *************
Create a2billing database
mysqladmin create mya2billing -u a2billinguser -p               Â
(prompt will ask you for password, in our case enter 'a2billing')
gibt mir:
************************************************************ **************
asterisk:~ # mysqladmin create mya2billing -u a2billinguser -p
Enter password: a2billing <--------this is the password I give.
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'a2billinguser'@'localhost' (using password:
YES)' Â <---------HIER IST DAS PROBLEM !!
Kann jederman mir bitte sagen was ich falsch mache?
Vielen dank.
Henk
(entschuldigung fuer mein Deutsch bitte !)