Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 02:09
    ThinkCats commented #1012
  • 02:07
    ThinkCats commented #1012
  • Aug 02 10:45
    soumendrak opened #1070
  • Aug 01 11:49
    rklak opened #1069
  • Jul 29 15:31
    dveeden commented #1068
  • Jul 29 15:18

    amjith on main

    Identify TiDB in the prompt. Include TiDB in tests and mycli… Merge pull request #1068 from d… (compare)

  • Jul 29 15:18
    amjith closed #1068
  • Jul 29 15:10
    amjith commented #1068
  • Jul 29 15:10
    amjith closed #1067
  • Jul 29 15:10
    amjith commented #1067
  • Jul 29 15:09
    dveeden opened #1068
  • Jul 29 15:08
    amjith opened #1067
  • Jul 29 15:08

    amjith on tidb

    Add TiDB changes to changelog. (compare)

  • Jul 29 15:05

    amjith on tidb

    Add TiDB to myclirc. (compare)

  • Jul 29 08:30
    dveeden commented #555
  • Jul 29 08:29
    dveeden commented #555
  • Jul 29 08:23
    dveeden commented #555
  • Jul 20 06:43
    cricalix opened #1066
  • Jul 13 19:17
    bnjmnbrmn-work opened #1065
  • Jul 13 17:08

    amjith on tidb

    Identify TiDB in the prompt. (compare)

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.
brightinnovator
@brightinnovator

I want to read 3 crore csv rows which is of 2GB csv file size and need to insert into MySQL via Java.

Could someone please help me know the fastest and memory efficient way to avoid out of memory exception as well load in lesser time?

Please kindly advise.

Kesavan Muthuvel
@kesavanm
Token.Keyword = "ansigreen bold" gives me ValueError: Wrong color format 'ansigreen'
Anyone facing this error?
Jean-Mark Wright
@jaywhy13
Hi, how do I remove the 100 row limit in mycli? I want to output a large number of rows to CSV
learningdeveloper2021
@learningdeveloper2021

Approaches to handle 10 million records of 10 tables each with several joins

I have 10 million records of 10 tables each with several joins. I am looking for the best alternative or DB assign or approach to read the records very quickly that is the query should be fast.

option#1 - normalize the tables, don't go for joins unnecessarily
option#2 - add all the columns in 1st query where multiple times the
where conditions will be used in the looping construct
option#3 - go for nosql database instead of mysql

Please advise

Thanks

J-TOBIN
@J-TOBIN
Hello I'm working with an employer that is looking to hire a permanent DBA (MySQL/MariaDB) for their office in Singapore + London. I had hoped that some members of this room may like to discuss with me further. I can be reached using "JamesBTobin (at) Gmail (dot) Com". Regards, James