You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/09 04:55:51 UTC
[GitHub] [shardingsphere] cqiwencom opened a new issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
cqiwencom opened a new issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712
**When i connect to shardingsphere-proxy:**
mysql -uroot -proot -P3307 -h127.0.0.1
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 65
Server version: 5.7.33-log-ShardingSphere-Proxy 5.0.0-beta
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> **select id,name,@@port from testdb.t1;**
ERROR 1046 (3D000): **_No database selected_**
MySQL [(none)]> use testdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [testdb]> use testdb;
Database changed
MySQL [testdb]> select id,name,@@port from testdb.t1;
+----+--------+--------+
| id | name | @@port |
+----+--------+--------+
| 1 | mm | 3318 |
| 2 | gg | 3318 |
| 3 | niuniu | 3318 |
| 4 | hhhh | 3318 |
| 5 | DBR920 | 3318 |
| 6 | 3316 | 3318 |
+----+--------+--------+
6 rows in set (0.01 sec)
### But when I connect directly to the back-end databaseļ¼
# mysql -uroot -proot -P3316 -h127.0.0.1
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 512125
Server version: 5.7.33-log MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> select * from testdb.t1;
+----+--------+
| id | name |
+----+--------+
| 1 | mm |
| 2 | gg |
| 3 | niuniu |
| 4 | hhhh |
| 5 | DBR920 |
| 6 | 3316 |
+----+--------+
6 rows in set (0.00 sec)
I don't need use database! Is there any way for shardingsphere-proxy to realize this function?
--
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
[GitHub] [shardingsphere] tristaZero commented on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-899024080
@cqiwencom Hi could you have a try?
--
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
[GitHub] [shardingsphere] taojintianxia commented on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
taojintianxia commented on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-900893897
hi there, today someone from the community ask the same issue. so I try the up to date cocde (code pulled in 2021-08-18), and the `no database selected` issue still exist
Navicat MySQL 12
![image](https://user-images.githubusercontent.com/4112856/129858006-8d4d49d4-d7bd-464a-bfad-5f36d97df5cb.png)
--
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
[GitHub] [shardingsphere] taojintianxia edited a comment on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
taojintianxia edited a comment on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-900893897
hi there, today someone from the community ask the same issue. so I try the up to date cocde (code pulled in 2021-08-18), and the `no database selected` issue still exist
Navicat MySQL 12
![image](https://user-images.githubusercontent.com/4112856/129858280-4499a2af-4fc8-48a5-8e09-760448317528.png)
--
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
[GitHub] [shardingsphere] RaigorJiang closed issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712
--
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
[GitHub] [shardingsphere] taojintianxia edited a comment on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
taojintianxia edited a comment on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-900893897
hi there, today someone from the community ask the same issue. so I try the up to date cocde (code pulled in 2021-08-18), and the `no database selected` issue still exist
Navicat MySQL 12
![image](https://user-images.githubusercontent.com/4112856/129858280-4499a2af-4fc8-48a5-8e09-760448317528.png)
--
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
[GitHub] [shardingsphere] strongduanmu commented on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-894985438
Hi @cqiwencom, thank you for your feedback, and we have implemented this feature in the master branch, and welcome to test.
--
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
[GitHub] [shardingsphere] RaigorJiang commented on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-927317556
Fixed in https://github.com/apache/shardingsphere/issues/11994
--
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
[GitHub] [shardingsphere] taojintianxia commented on issue #11712: ShardingSphere-Proxy 5.0.0 return 'No database selected'
Posted by GitBox <gi...@apache.org>.
taojintianxia commented on issue #11712:
URL: https://github.com/apache/shardingsphere/issues/11712#issuecomment-900893897
hi there, today someone from the community ask the same issue. so I try the up to date cocde (code pulled in 2021-08-18), and the `no database selected` issue still exist
Navicat MySQL 12
![image](https://user-images.githubusercontent.com/4112856/129858006-8d4d49d4-d7bd-464a-bfad-5f36d97df5cb.png)
--
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