dbcli/mycli

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

Prajjwal Datir

@PrajjwalDatir

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

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

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

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

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

Where communities thrive

People

Repo info

Activity