| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
07-08-06, 12:59
|
|
Registered User
|
|
Join Date: Jan 2006
Posts: 8
|
|
Urgent, mySQL remote access problem.
|
|
Hi,
I've a mySQL server running on freeBSD Box and I cann't connect myself to mySQL with root user from an external PC, but with the "informix" user I can do it.
This are my user and db tables (The passwd isn't real):
I've tried from my PC(WinPX) : sistemas1.dom.cu
mysql> select host, user, password from user order by host desc; +------------------+--------+---------------------------------+
| host | user | password |
+------------------+--------+---------------------------------+
| sistemas1.dom.cu | | |
| localhost | root |*EF9E58BF0792C14192C8CD7A |
| localhost | | |
| localhost | jabberd2 |*135D0CFD9A70B3032C179A49EE7 |
| localhost | informix |*F7C661CB9EDE1B60443761D88D6FF |
| gw.dom.gcc.cu | | |
| %dom.cu | www |*D34BBEBD1265092FD451E9CEA86ABC |
| %dom.cu | informix |*9FF7C661CB9EDE1B60443761D88D6FF |
| %dom.cu | root |*508ED8DEF9E58BF0792C14192C8CD7A |
+-----------------+--------+--------------------------------------+
mysql> select host, db, user from db;
+-----------+----------+----------+
| host | db | user |
+-----------+----------+----------+
| % | mttsa | www |
| % | mtts | informix |
| % | test | |
| % | test\_% | |
| localhost | jabberd2 | jabberd2 |
+-----------+----------+----------+
What do I miss?
|
|
07-14-06, 05:06
|
|
Registered User
|
|
Join Date: Feb 2005
Location: Mumbai, India
Posts: 161
|
|
Code:
CREATE USER 'root';
SET PASSWORD FOR root = PASSWORD('mypassword');
GRANT ALL ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
OR
Code:
INSERT INTO `user`
( `Host` , `User` , `Password` , `Select_priv` , `Insert_priv` , `Update_priv` , `Delete_priv` , `Create_priv` , `Drop_priv` , `Reload_priv` , `Shutdown_priv` , `Process_priv` , `File_priv` , `Grant_priv` , `References_priv` , `Index_priv` , `Alter_priv` , `Show_db_priv` , `Super_priv` , `Create_tmp_table_priv` , `Lock_tables_priv` , `Execute_priv` , `Repl_slave_priv` , `Repl_client_priv` , `Create_view_priv` , `Show_view_priv` , `Create_routine_priv` , `Alter_routine_priv` , `Create_user_priv` , `ssl_type` , `ssl_cipher` , `x509_issuer` , `x509_subject` , `max_questions` , `max_updates` , `max_connections` , `max_user_connections` )
VALUES
('%', 'root', 'mypassword', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', '0', '0', '0', '0');
__________________
MySQL 5.1
|
|
07-14-06, 10:31
|
|
Registered User
|
|
Join Date: Jan 2006
Posts: 8
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Urgent, mySQL remote access problem.
