You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by "newFisherkk (via GitHub)" <gi...@apache.org> on 2024/06/17 09:40:42 UTC

[I] how to set mysql system variables [shardingsphere]

newFisherkk opened a new issue, #31735:
URL: https://github.com/apache/shardingsphere/issues/31735

   
   The database that needs to be proxied is MySQL. The system variable values of the master and slave databases are both 1（for lower_case_table_names）
   
   ![1718616744002](https://github.com/apache/shardingsphere/assets/49480676/484e6582-1059-4707-a7c3-a565a7b9fa78)
   
   
   but after connecting to the proxy server, the value is 0. I don't know where to set it.
   ![image](https://github.com/apache/shardingsphere/assets/49480676/8a3ff309-6f15-45dc-b8d3-54e7f6ff4a46)
   
   Variable 'lower_case_table_names' is a read only variable
   
   ![image](https://github.com/apache/shardingsphere/assets/49480676/7d08df48-b12b-4d3b-9319-b3c3740538b0)
   
   I set the value in the console window connected to the proxy server, but there was no change
   ![image](https://github.com/apache/shardingsphere/assets/49480676/98831906-9918-4102-93f7-c7c14f135243)
   
   Based on the above, I hope to find a way to set this system variable


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] How to set the proxy server system variables [shardingsphere]

Posted by "newFisherkk (via GitHub)" <gi...@apache.org>.

newFisherkk commented on issue #31735:
URL: https://github.com/apache/shardingsphere/issues/31735#issuecomment-2232740803

   I tried it on versions 5.4.1 and 5.5.0


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] How to set the proxy server system variables [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.

terrymanu commented on issue #31735:
URL: https://github.com/apache/shardingsphere/issues/31735#issuecomment-2230719860

   What is your version?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] How to set the proxy server system variables [shardingsphere]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.

github-actions[bot] commented on issue #31735:
URL: https://github.com/apache/shardingsphere/issues/31735#issuecomment-2229294339

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org