Stack Overflow
Stack Overflow

Questions tagged [mysql-cli]

46 questions
0
votes
0 answers

Cannot enter mysql shell with user in windows

Username : mohit mysql -u mohit -h localhost -p While I am trying to enter username mohit in my mysql shell in windows with/wo sudo prefix it is going to next line as Entering passowrd does not work
Jayesh
  • 3
  • 5
0
votes
2 answers

How to exit "->" in macOS terminal for mysql?

I was testing commands like "status" for mysql, then I suddenly entered this mode I don't recognize. Can not do anything from here. Whatever I entered, it's just roll into next line.
Lioncake
  • 9
  • 2
0
votes
2 answers

Mysql on iMac : command not found

I have a problem installing mysql on my Mac. I followed a tutorial, but I did not succeed. So after having downloaded version 8.0.26 (which can be found in my system preferences), I went to the terminal to finalize all this. I used the following…
Iguana7
  • 1
  • 1
0
votes
0 answers

Cant login in Mysql Command Line

[enter image description here][1] Hello I´m trying to use Mysql Command Line (8.0) and all tutorials begin with the command mysql -uroot -p or mysql -u root -p or some variant in order to connect, and then they enter the password. But for me I only…
SamV
  • 1
  • 2
0
votes
2 answers

Not Able To Deploy Django App Because of This Error How To Fix It

ERROR: mysqlclient-1.4.6-cp38-cp38-win32.whl is not a supported wheel on this platform. ! Push rejected, failed to compile Python app. ! Push failed
user14755472
0
votes
0 answers

How to pretty-print SHOW CREATE VIEW output in MySQL CLI?

You can run SHOW CREATE VIEW someview; to see the view definition. However, MySQL returns the definition without line breaks making it very hard to read. Doing SHOW CREATE VIEW someview \G is slightly better as it doesn't result in multiple lines…
Tobias Mühl
  • 1,788
  • 1
  • 18
  • 30
0
votes
0 answers

MySQL / MariaDB: CLI only supports less than 80 characters, expected or bug?

I have set up a new MariaDB Server on a server with Debian Stable and configured a new SQL user, call it 'user', with the password '123456' (EDIT: I used a generated password with exact 80 characters). I can now use mysql -uuser -p123456 on the…
Felix Stupp
  • 81
  • 8
0
votes
1 answer

MySQL Error 1064 with UPDATE, but query looks correct

Im not sure whats going on here mysql> update messages set read=1 where id=4; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read=1 where…
Jeffrey L. Roberts
  • 2,844
  • 5
  • 34
  • 69
0
votes
1 answer

mysql command line sql execution mystery, only part of the string is considered

from command line from my Mac terminal: mysql --host=127.0.0.1 --port=3306 -uroot -p"mypass" wordpress -e "update users set user_pass = '$1$Hat7oFty$mA.L2vsQdD3MxvxAuDFKp0';" completes successfully... however.... only .L2vsQdD3MxvxAuDFKp0 is written…
JasonGenX
  • 4,952
  • 27
  • 106
  • 198
0
votes
0 answers

Query execution was interrupted, ERROR 1317 (70100)

I use mysql command mysql -uuser -ppassword -B -e "SELECT SUM(duration) FROM table GROUP BY userId" database > result.tsv & This is a very slow SQL, I need to use & let SQL execute in the background. which takes about a few hours. But always…
doushichao
  • 23
  • 2
  • 5
0
votes
0 answers

mysql client: change output columns separator

Thought of this to be a very basic issue which people would have definitely faced. But unfortunately, I couldn't find a solution for this after searching a lot. I am using mysql command line client to run a query, and later on parse the output as…
pratpor
  • 1,954
  • 1
  • 27
  • 46
0
votes
0 answers

mysql -r -s -N tabbed output: how can I handle line breaks and tabs in the data?

I am writing a batch script that needs to get some log in tab separated format. Problem is that some of the items in the log contains line breaks (\n) and this make lines that don't adhere to the number of columns I expect. is there any way I can…
www.jensolsson.se
  • 3,023
  • 2
  • 35
  • 65
-1
votes
1 answer

mysqldump sql file save without content

i have this php script.when i run the script mysqldump, The file got saved but the content is empty. Any help is appreciated. thank you. $filename = "backup-" . date("YmdHis") . ".sql"; $pathfile = public_path('database') .'/'…
No One
  • 109
  • 10
-1
votes
1 answer

import and export mysql table to xml file in windows command?

am using Mysql server version "MySQL Server 8.0". please help me, how to export and import mysql table to xml file, in windows command prompt. thanks.
doe
  • 27
  • 4
-2
votes
2 answers

When connecting using the mysql cli, why is there no space between -p and the password? e.g. -ppassword

mysql -hhost -uuser -ppassword Is there a rationale behind why there's no need for spaces? In fact, it wouldn't work unless there is no space.
geoyws
  • 3,326
  • 3
  • 35
  • 47
1 2
3
4