MySQL access

gmaoret

Joined
Nov 13, 2007
Messages
50
Likes
0
Points
0
#1
What's the UseID and the Password for access to MySQL inteface in Elastix 9.2?
 

ramoncio

Joined
May 12, 2010
Messages
1,663
Likes
0
Points
0
#2
root / eLaStIx.2oo7
 

gmaoret

Joined
Nov 13, 2007
Messages
50
Likes
0
Points
0
#3
Using that UID/PWD:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I have a fresh install of versione 0.9.2-4
 

ramoncio

Joined
May 12, 2010
Messages
1,663
Likes
0
Points
0
#4
You must be doing something wrong...

[root@pbx ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
the password is eLaStIx.2oo7
(notice they've used "o" letters instead of zeros in 2oo7)

Or you can try with webmin mysql module. It is easier.<br><br>Post edited by: ramoncio, at: 2008/01/16 23:57
 

gmaoret

Joined
Nov 13, 2007
Messages
50
Likes
0
Points
0
#5
ok, it works if I copy and paste the password.

Probably it's my terminal app that don't pass it correctly.

Bye
 

haamed

Joined
Jul 23, 2007
Messages
251
Likes
0
Points
0
#6
Hi,
i have this problem with mysql login:

> mysql -u root -p eLaStIx.2oo7
Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I use copy and paste,!
but i thing it has another problem.
 

haamed

Joined
Jul 23, 2007
Messages
251
Likes
0
Points
0
#7
it was solved ! :p :blush:
 

aliarjmandi

Joined
Aug 20, 2008
Messages
11
Likes
0
Points
0
#8
Hi
I want to connect Mysql from windows (Nivacat 8 for mysql) .
I edit cdr_mysql.conf

[global]
hostname=192.168.100.5
dbname=asteriskcdrdb
password=eLaStIx.asteriskuser.2oo7
user=asteriskuser
userfield=1
port=3306
;sock=/tmp/mysql.sock

but when i connect i give this message
Host 192.168.100.55(my pc)' is not allowed to connect to this my sql server

please help me
 

aliarjmandi

Joined
Aug 20, 2008
Messages
11
Likes
0
Points
0
#9
Solved

mysql> INSERT INTO user (Host,User,Password)
-> VALUES('192.168.100.55','admin',PASSWORD('123456'));

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'192.168.100.55'
-> IDENTIFIED BY '123456' WITH GRANT OPTION;

192.168.100.55 = address of guest want to connect
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,938
Messages
130,959
Members
17,631
Latest member
nabeel
Top