Hi,
Hope you all are at good health
.I have some confusion about mysqladmin and mysql.I am using mysql version
Quote:
[root@localhost freepbx-2.7.0]# mysql --version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
|
My MySQL is running
Quote:
[root@localhost freepbx-2.7.0]# /etc/init.d/mysqld status
mysqld (pid 11440) is running...
|
I have a root account named root and i am easily connect with it.When i try to execute command. I get the following error
Quote:
[root@localhost freepbx-2.7.0]# mysqladmin create asterisk
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
|
If i connect to mysql root account by mysql -u root -p and after that if i execute command then i get this
Quote:
[root@localhost freepbx-2.7.0]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> mysqladmin create asterisk
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin create asterisk' at line 1
mysql> mysqladmin create asterisk;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin create asterisk' at line 1
mysql>
|
I want to ask why this command is not working
Quote:
[root@localhost freepbx-2.7.0]# mysqladmin create asterisk
|
Do i suppose to start mysqladmin like i start mysql(/etc/init.d/mysqladmin start or something like this)
I am using
Quote:
[root@localhost freepbx-2.7.0]# mysqladmin --version
mysqladmin Ver 8.41 Distrib 5.0.77, for redhat-linux-gnu on i686
|
Also in mysqladmin create asterisk. Is asterisk is a username or database name?
Thanks you.