Connecting to MySQL

[Former Member]

Hi Friends

I was working with MySQL database (Inserting and Retrieving data from it). It worked fine for me for some days. But now it gives an error in RWB.

<b>Receiver Adapter v1109 for Party '', Service 'ORACLE_SERVER_BS':

Configured at 06:32:46 2006-01-24

Processing Error: Accessing database connection 'jdbc:mysql://172.25.5.149:3306/MYSQL' failed: java.sql.SQLException: null, message from server: "Host 'sapbl2.----

---

.com' is not allowed to connect to this MySQL server"

Addtional information: JDBC driver 'com.mysql.jdbc.Driver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

com.mysql.jdbc.Driver, 3.1 NOT JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant</b>

(Company Name is removed)

What could be the reason for this? And how to solve this.

Thanks in Advance..

regards,

Raju.

[former_member189324]

Hi Raju,

Looks like the driver for the Mysql you have installed is not JDBC Complaint. Check whether you have any updated drivers for mySQL

Thanks

Prasad

[bhavesh_kantilal]

Hi raju,

I think the problem is with your connection url. Just check if the host where your DB server is up and running and make sure you have given the proper info for the connection URL.

Hope this helps,

regards,

bhavesh

[former_member184154]

Have you checked the the privileges?

Looks like the mysql user of xi connection cannot login anymore from the xi host.

Go with phpMyAdmin (I hope you have it in the Privileges section and check that the mentioned user has grants on sapbl2.----

---

.com host, or % (meaning all).

[Former Member]

Hi

Thanks for the Replies....

I have checked all the Connection parameters and Drivers . they are all present.

How to check the privileges?

Can you please give a step by step procedure for that. And what is phpMyAdmin?

[former_member184154]

Sure you can set the privileges also without phpMyAdmin, that is a php web application for administering mysql (www.phpmyadmin.net) that needs a web server (typically Apache) and php. Very useful.

Take a look at http://www.mysql.com/doc/en and look for the privileges chapter (should be easy as using the GRANT command).

Alex

[Former Member]

Hi Narayana,

this is sometimes confusing... Please check if your driver is JDBC compliant.

Otherwise their was another discussion about this theme. May you find some other information's in their.

Regards

Matt

[Former Member]

Hi

I have given the Granted some privileges to sapbl2 using the command

GRANT SELECT,INSERT,UPDATE ON . TO root@sapbl2.---.com

and now it gives me the error...

<b>Sender Adapter v1209 for Party '', Service 'ORACLE_SERVER_BS':

Configured at 11:18:34 2006-01-24

Processing Error: Accessing database connection 'jdbc:mysql://172.25.5.149:3306/MYSQL' failed: java.sql.SQLException: Access denied for user 'root'@'sapbl2.lntinfotech.com' (using password: YES)

Addtional information: JDBC driver 'com.mysql.jdbc.Driver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

com.mysql.jdbc.Driver, 3.1 NOT JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant

last retry interval started 11:40:23 2006-01-24

length 60,000 secs</b>

What is the reason and how to resolve this?

[former_member184154]

You probably forgot the password option.

GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
    ON [object_type] {tbl_name | * | *.* | db_name.*}
    TO user [<b>IDENTIFIED BY [PASSWORD] 'password'</b>]

I would try issueing again the same command you used adding this option with the right root pwd of course.

Alex

[Former Member]

Hi Alex,

thanks for the reply.

I tried to give the same command

GRANT SELECT,INSERT,UPDATE ON . TO 'root'@'sapbl2.---.com' identified by password 'abcd';

but this gives me error

ERROR 1105 <HY000>: Password hash should be a 41-digit hexadecimal number.

So what is the format of password should I specify.

Iam new to mySQL so please help me out.

Thanks in Advance.....

[former_member187339]

Hi

Try this:

GRANT SELECT,INSERT,UPDATE ON . TO 'root'@'sapbl2.---.com' <b>IDENTIFIED BY</b> 'abcd'

Regards

Suraj

[former_member184154]

Just remove the PASSWORD statement (In that case you have to use the PASSWORD function to create the hash), like this:

GRANT SELECT,INSERT,UPDATE ON *.* TO 'root'@'sapbl2.<i>company</i>.com' identified by 'abcd';

I just tried that and it works.

Remember to replace <i>company</i> by what you really need

[Former Member]

Hi Alex

I specified the same syntax now it says

Query OK, 0 rows affected.

But my error in RWB remains the same that is

access denied for user 'root'@'sapbl2.lntinfotech.com' (using password:YES)

Why still the problem exists?

[former_member184154]

mmh, strange...

sorry for stupid question, but passwords match?

try copy-paste the content of the mysql.user table

select * from mysql-user where user='root'

and don't worry, password is hashed (no security holes!)

[former_member187339]

Hi

Go thru these links:

http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Access_denied.html

Regards

Suraj

[Former Member]

Hi

Thanks a lot.

You people have solved my problem.You are really Great.

Thanks again...

I have given points to you all.