Search Results

Hi,

I know the API to get protocol version, character set etc. If I want to find out the current protocol version, current user character set, mysql info, mysql server info wihtout using these API...

Thanks for the reply.

I have used same command on both the machine using IP address, but still it is giving the same error as "ERROR 1045 (28000): Access denied for user.

I have also removed...

Hi,

I have MySQL 5.1.34 installed on Solaris and Linux machine.

MySQl installed Solaris Machine - A.A.A.A
Remote Machine - B.B.B.B

I have user in mysql.user as below:

| user | ...

Hi Neo,

Does "Switching Masters During Failover" supports for prior to version 4.1?

I found this point in 5.0 onward manual and not in "MySQL 3.23/4.0/4.1" manual.

Can you please tell me it...

Hi,

I need setup like:

Consider, Master - A and Slave - B machine.

We do operations on master will replicate to Slave. But in case if

Case 1:

If master(A) goes down then...

Thanks for the prompt reply.

Let me know if We can make a setup like using MySQL.

We have master - A and slave - B setup.

Case 1:

If master(A) goes down then slave (B) becomes a master....

Hi All,

Can anybody tell that Where is to find simple and easy steps of ORACLE replication process?

Any help on this highly appreciated.

http://www.unix.com/images/misc/progress.gif...

Hi All,

Can anybody tell that Where is to find simple and easy steps of ORACLE replication process?

Any help on this highly appreciated.

Thanks.

Hi All,

Does MySQL supports Synchronous Replication? If it is then From which version it is supported and how?

Any help on this highly appreciated.

Thanks.

when I use "mysqlclient.lib" (mysql 5.1.34) on windows in my code and trying to compile the code it gives error as:
mysqlclient.lib(trees.obj) : error LNK2001: unresolved external symbol...

when I use "mysqlclient.lib" (mysql 5.1.34) on windows in my code and trying to compile the code it gives error as:
mysqlclient.lib(trees.obj) : error LNK2001: unresolved external symbol...

Hi,

I have build one application which uses static reference of MySQL 4.0 old version library and dynamic reference of new version as MySQL 5.1 version library.
On Solaris
When I try to...

I am trying to connect to MySQL installed on windows from Solaris machine.

While doing this getting error as:

"Client does not support authentication protocol requested by server; consider...

Thanks. It is worked for me.

---------- Post updated at 08:58 PM ---------- Previous update was at 05:59 AM ----------

I am trying to build the my project on HPUX (HP-UX oscar B.11.11 U...

If I have installed mysql using "mysql-essential-5.1.34-win32.msi" on "Comp1" and I want to connect to Comp1-> Mysql server from Comp2.

Then Is there any client requirement on Comp2 (like Oracle...

ok Thanks for your prompt reply.

But this tells that we can use the role in My SQL.

MySQL :: MySQL Workbench :: 7.4.3.1 Adding Roles (http://dev.mysql.com/doc/workbench/en/wb-adding-roles.html)

How can we get the role information in MYSQL?

Like we get in ORACLE from USER_ROLE_PRIVS table.

Hi,

I have created 4 tables in 'amit' database and then I deleted them. Still I able to get information about the table_schema for the table deleted.
After drop table when I fire a query for...

Ok. I will create new thread.

How do I get the native data type like we get in ORACLE using

OCIAttrGet(colHandle, OCI_DTYPE_PARAM, (dvoid *) &dataType, 0,
OCI_ATTR_DATA_TYPE, m_errorHandle);

It will return &datatype value...

How do I get the native data type like we get in ORACLE using

OCIAttrGet(colHandle, OCI_DTYPE_PARAM, (dvoid *) &dataType, 0,
OCI_ATTR_DATA_TYPE, m_errorHandle);

It will return &datatype value...

Thanks you very much. I solved my problem.

Thanks. I got the information from INFORMATION_SCHEMA COLUMNS.

While retrieving the data from the result of query I faced following problem.

mysql> select select COLUMN_NAME, DATA_TYPE,...

How can we get the table schema information in MYSQL 5.1.34?

Like we use in ORACLE to get it as:

OCIDescribeAny() // //get the describe handle for the table to be described.

OCIAttrGet() ...