Stack Overflow
Stack Overflow

Questions tagged [mysql-cli]

46 questions
1
vote
1 answer

Correct use of mysqli_real_escape_string for insert,select and update statement - PHP/Oracle

I need to know if this code works when a user update,insert or search for something in my database. I'm not familiar with mysqli_real_escape_string yet. Do i need to use $_SESSION here if we're talking about user input ? $connmaj = new…
user9939473
  • 43
  • 6
1
vote
0 answers

How does mysqldump know what databases exist and where they are located?

THE ISSUE This is a simple question that has a verifiable answer somewhere, I just can't seem to find it. This is a "how stuff works" type question, as opposed to a "help me fix a bug". I'm trying to understand how mysqldump works. WHAT I'VE TRIED…
Eric Hepperle - CodeSlayer2010
  • 3,745
  • 10
  • 38
  • 53
0
votes
0 answers

MySQL query's execution time

When in mysql client prompt I execute a query on a table with over 100k rows: select * from jmeterschema.tabela_inz; #I just retrieve data from it. The execution time shown after executing is e.g 0.12sec, yet the prompt to actually retrieve the data…
Mateusz G
  • 1
0
votes
0 answers

MySQL comman line client won't open

I have been trying to reset MySQL (latest version) password (which the installation manager did not allow me to set up in the first place, I tried re-installing it about 5 times) in windows cdm. I did everything as per MySQL site, however MySQL…
Bart
  • 1
  • 1
0
votes
1 answer

How to read .sql file by dictionary on MacOS?

I got error 2 when exec sql file by dictionary I tried to exec mysql file on Mac OS at this dictionary: "/Users/kato/Desktop/world_mysql_script.sql" source /Users/kato/Desktop/world_mysql_script.sql; Then I got this error: Failed to open file…
Kato
  • 1
0
votes
1 answer

Trying to run MySql script gives error "Failed to open file" error: 22, even though the file exists

I have been asked to take over development of a Delphi application that uses MySql 5.7.40. Amongst the information I was given was a dump of the database as an .sql file. I installed MySql 5.7.40 (although I got version 8.0.31 of some of the related…
DelphiNewbie
  • 39
  • 5
0
votes
0 answers

The difference between MySQL Workbench and MySQL client

I have installed both MySQL Workbench and MySQL client console (Using Ubuntu WSL). When I tried to connect to MySQL Server and query. The MySQL Workbench returns typically but the MySQL client returns with errors: ERROR 2006 (HY000): MySQL server…
Sefirosu
  • 11
  • 2
0
votes
0 answers

Column widths are broken for non-latin characters in console

I have this rather inconvenient problem with mysql console client, the column widths in display are broken for non-latin characters, i.e. mysql makes the column 1.5 times wider than it needs to be for Chinese characters, Cyrillic is even worse, the…
exebook
  • 32,014
  • 33
  • 141
  • 226
0
votes
1 answer

skip-column-names not working for a call inside script

I have a stored procedure myProc defined within a file stored_proc.sql that has select statements to report on various things. If call myProc within stored_proc.sql, skip-column-names works. I'd like to call myProc within another file overall.sql,…
Marko Galesic
  • 472
  • 5
  • 17
0
votes
0 answers

I am not able to access Mysql CLI

Getting error when I access Mysql in CLI mode 'mysql: [ERROR] unknown variable 'expire_logs_days=3' I tried expire log day change in my.cnf file
Santosh Amkare
  • 1
0
votes
1 answer

Can anybody help me identify the error in this statement?

The table looks like this mysql> DESCRIBE tenants; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra …
Vromahya
  • 51
  • 6
0
votes
1 answer

AWS RDS MySql: connect from local Workbench

I am very much confused right now, since a connection from my local MySQL workbench to an instance in AWS RDS does not work anymore. I have a dynamic IP, so I edited the inbound rules in the AWS security group to reflect that, but I am still getting…
Moritz
  • 495
  • 1
  • 7
  • 17
0
votes
1 answer

MySQL 8.0 Command Line Client closes after I input my password

I'm a total beginner at this, and I just installed mySQL by following a tutorial. My problem is that the mysql command line crashes after I input my password without any error messages. It just straights up exits itself after I enter the password.…
TheShin
  • 77
  • 5
0
votes
0 answers

MySQL asks password every time

Server: Ubuntu 20.04 MySQL version: MySQL Server version: 8.0.27-0ubuntu0.20.04.1 No changes in config were made. But server was rebooted and dpkg.log is lost, so I can't say was there update since last time or not. Problem is that earlier when I…
DuhVir
  • 447
  • 1
  • 4
  • 15
0
votes
0 answers

How stop user in client-side from using MySQL commands when set password to expire from server side during client log in?

I use root to log in on local MySQL Server Machine 192.168.156.33 and create new user test for anonymous host % CREATE USER test IDENTIFIED BY 'password'; I use client machine to log in with user test mysql -u test -h 192.168.156.33 -p I use server…
Somethea Yuon
  • 1
  • 1
1
2
3 4