Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jun 04 07:52
    LordFoom closed #990
  • Jun 04 03:50
    laixintao commented #984
  • Jun 03 20:16
    LordFoom commented #990
  • Jun 03 20:15
    LordFoom commented #990
  • Jun 02 19:31
    meeuw commented #990
  • May 26 01:59
    thevan96 opened #989
  • May 25 08:13
    omaidb opened #988
  • May 24 16:19
    j-bennet closed #987
  • May 24 16:19
    j-bennet commented #987
  • May 24 08:36
    dujbo opened #987
  • May 14 23:35
    amjith commented #978
  • May 14 23:29
    amjith closed #986
  • May 14 23:29
    amjith commented #986
  • May 14 23:22
    amjith commented #986
  • May 14 22:43
    mannerydhe opened #986
  • May 14 11:17
    omaidb commented #978
  • May 11 17:20
    wjWu00 commented #980
  • May 10 03:32
    wjWu00 commented #980
  • May 10 03:32
    wjWu00 commented #980
  • May 09 06:30

    meeuw on unicode

    (compare)

BayMRX
@BayMRX
Does anyone know about this?
this is mycli, and it's normal in mysql
颜虎
@luojianet
hello
image.png
谁能帮我看下这个问题
aytrack
@aytrack
Hi, when I execute multiple statements in the current mycli after a certain statement in the middle fails, the subsequent statement will not continue to execute, how should I set it to continue to execute the following sql when there is a failed statement
Prajjwal Datir
@PrajjwalDatir
image.png
Hello, I'm newbie in SQL.
So my question is when I do
CREATE database 'something';
in MariaDB it works
but when I do it in mycli it shows
(1044, "Access denied for user ''@'localhost' to database 'something'")
What do I do?
Prajjwal Datir
@PrajjwalDatir
image.png
ACe
@alienhunter3010
Goodmorning. I'm new on gitter and on mycli too
I'm trying to customize stuff and I think it will be really cool to add colors to prompt (like escape codes?) so mycli and powerline could work together! What do you mean?
zhurongpeng
@zhurongpeng
image.png

select id, name from users in (156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 156963, 156964, 156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 15
6963, 156964, 156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 156963, 156964);

When I copy, there is an extra space. How do I solve this problem

156963 becomes 15 6369
What do i do? Can this be done by configuration
ACe
@alienhunter3010
No, this depends from the terminal. I think you solve with multiline enabled (F3). Remember to close query with ;
zhurongpeng
@zhurongpeng
I've tried it, and whether It's enabled or disabled, the result is the same
ACe
@alienhunter3010
You need to explicite break the query line by line on the right place
zhurongpeng
@zhurongpeng
Yes, now I also do so, I think there should be a solution, but I don't know
Ganesh Chandrasekaran
@gchandra_twitter

hi mycli users.. I'm facing an issue.. hope someone has an answer.
When I try to connect to MySQL 8 which has SSL on.. I get this error.

(3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')

Any trick to bypass the ssl and connect to it. Its a remote server where I dont get to control or access to certificate.

anchithAcharya
@anchithAcharya
Hey, does anyone have an idea on how to clear the screen in mycli?
ACe
@alienhunter3010
Ctrl+L - it works outside too :D
anchithAcharya
@anchithAcharya
Damn, didn't know that. Thanks a lot!
Logan Weaver
@LoganW_gitlab
image.png
Hey all, had a quick question. On an older install I was able to have a full query autocomplete. I can't seem to get that on a new install. Anybody know how to turn that on again?
ACe
@alienhunter3010
It works for me, it uses the history, I think. So maybe you need to launch more queries, before it will be useful
Logan Weaver
@LoganW_gitlab
I wound up figuring it out. I had installed it using apt-get which for some reason on Ubuntu 18 only has version 1.8 of mycli. I installed it using PIP instead and voila I got version 1.16 and have my full query autocomplete back. Thanks for the help though!
ACe
@alienhunter3010
I'm using mycli from July 2020, and I installed it directly from pip. Good that you solve it ;)
Alex Yelluas
@hiphamster
Hello fellow mycli users! Is it possible to add aliases / custom commands into mycli?
Logan Weaver
@LoganW_gitlab
Depends on what you mean, you can favorite queries that will get set to a custom name that you can run by doing \f query_name. Here's the the docs: https://www.mycli.net/favorites hopefully that's somewhat what you were looking for?
Alex Yelluas
@hiphamster
@LoganW_gitlab Thanks, this is quite useful
Bill Maca
@bmaca
Hey folks does anyone happen to know how I can shut off the interactive mode in mycli
i want everything to go to stdot instead it drops me into the interactive mode
Bill Maca
@bmaca
@channel
I found it
no pager
nopager
Suryaobulareddy2932
@Suryaobulareddy2932
Hi
I'm new to mysql database
I would like to know anyone using mysql with timeseries data?
Ahmad Y. Alrawi
@ahmad1995
Hello guys , so im trying to connecto to my local mariadb server and this error triggers everytime
mycli -S/var/lib/mysql/mysql.sock -P 3306 -u root -p0000
Traceback (most recent call last):
File "/usr/bin/mycli", line 9, in <module>
load_entry_point('mycli==1.22.2', 'console_scripts', 'mycli')()
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 489, in load_entry_point
return get_distribution(dist).load_entry_point(group, name)
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 2852, in load_entry_point
return ep.load()
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 2443, in load
return self.resolve()
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 2449, in resolve
module = import(self.module_name, fromlist=['name'], level=0)
File "/usr/lib/python2.7/site-packages/mycli-1.22.2-py2.7.egg/mycli/main.py", line 441
f"Connecting to socket {socket}, owned by user {socket_owner}")
is it a python issue or is it the socket
seabass
@seabass:chat.weho.st
[m]
@ahmad1995: I'm not an database expert by any stretch of the imagination, but by all means post the error message here and I shall take a look at it!
Georgy Frolov
@pasenor
@ahmad1995 it's a bug that was introduced in version 1.22.2 and fixed in 1.23. Please upgrade.
Georgy Frolov
@pasenor
IMPORTANT INFO: this chat is discontinued as the official support channel. The dbcli team occasionally visits here, but we do not promise a timely reaction. The best way to get support is to open an issue on https://github.com/dbcli/mycli/issues
Roman Blanco
@romanblanco

:point_up: February 11, 2020 12:45 AM

@MartynKeigher dbcli/mycli#872

Selçuk Karakayalı
@karakays

hey there - I am having issues with mycli regarding the --login-path argument although same configuration works for mysql client.
This fails and asks me password

mycli --login-path=foo -D bar
Connecting to socket /tmp/mysql.sock, owned by user 
Password:

This works

mysql --login-path=foo -D bar

What could be the problem?

~ $ mysql --version
mysql  Ver 14.14 Distrib 5.7.32, for osx10.15 (x86_64) using  EditLine wrapper
~ $ mycli --version
Version: 1.23.2
Alex Yelluas
@hiphamster
howdy, how do i echo / print mycli setting? i.e. i set key_bindings to vi, how can i inspect key_bindings var?
Cheong Chung Onn
@chungonn

Hi, I am using mycli version 1.23.2 on ubuntu 21.04. I need to provide both the -p switch together with password in order to use mycli. With either or both the password or -p switch left out, I will get an error message, see below.

This has been raised as an issued dbcli/mycli#973

Any help is much appreciated.

❯ mycli -u root
Connecting to socket /var/run/mysqld/mysqld.sock, owned by user mysql
(1698, "Access denied for user 'root'@'localhost'")
Cheong Chung Onn
@chungonn
I forgot to mentioned that I am using mariadb 10.5, and my coworkers told me I need to use sudo along with the command. It is working for me now.