Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [mysql]

An open-source, relational database management system.

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. Its source code is available under the GNU (General Public License).

MySQL offers standard database driver connectivity for using MySQL with applications and tools that are compatible with industry standards ODBC and JDBC.

For more details about questions using tag mysql, refer to StackOverflow.

971 questions
88
votes
6 answers

How to pass password to mysql command line

I have MySQL password saved on a file foo.php, for example P455w0rd, when I try to use it: $ cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2 | mysql -U root -p mydb -h friendserver Enter password: (holds) $ echo P455w0rd | mysql -u root -p mydb -h…
Kokizzu
  • 9,257
  • 12
  • 55
  • 82
52
votes
2 answers

Where does MySQL store its databases on Debian?

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files. Does anybody know where to look for them in a Debian Linux server?
arok
  • 623
  • 1
  • 5
  • 7
34
votes
1 answer

Anyone know a good gui to MariaDB?

I'm using MariaDB instead of MySQL in Slackware 14.1, and I need a graphic manager like MySQL Workbench. Can anyone suggest me something? I tried using MySQL WorkBench but it could not connected with MariaDB.
Patterson
  • 765
  • 3
  • 12
  • 25
33
votes
4 answers

Get a progress indicator when importing MySQL databases

I often import MySQL databases, and this can take a while. There is no progress indicator whatsoever. Can one be shown, somehow? Either records imported, MB imported, or tables imported... anything is better than just waiting. Anybody any idea? I…
user
  • 915
  • 7
  • 27
  • 38
25
votes
5 answers

Turn off --skip-grant-tables in MySQL

I'm pretty new to using Linux but am setting up my MySQL databases on an Amazon ec2 instance. I followed some directions I found about resetting the user login pass by using the --skip-grant-tables option of MySQL. Now I am trying to add a user and…
user718229
  • 365
  • 1
  • 3
  • 6
24
votes
5 answers

install mysql - has no installation candidate

I used to install mysql 5.6 in this way.. But now.. # echo "deb http://repo.mysql.com/apt/debian/ $(lsb_release -sc) mysql-5.6" >> /etc/apt/sources.list && echo "deb-src http://repo.mysql.com/apt/debian/ $(lsb_release -sc) mysql-5.6" >>…
clarkk
  • 1,727
  • 6
  • 31
  • 43
19
votes
4 answers

Can I copy a MySQL database by copying the files? What do the files contain exactly?

I am using MySQL database and using an Ubuntu Linux machine. My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following: /var/lib/mysql/db_test# ls cars.frm cars.MYD…
Mellon
  • 1,029
  • 7
  • 19
  • 24
17
votes
9 answers

Encrypt a password the same way mysql does

I've created a user ... but forgotten the password mysql> create user 'blayo'@'%' identified by 'right'; Which Linux command line tool can encrypt the password the same way mysql 5.5 does ? mysql> select Password,User from…
Philippe Blayo
  • 1,949
  • 4
  • 18
  • 23
17
votes
2 answers

Installing mysql-server in vagrant bootstrap shell script (how to skip setup?)

I did try to install mysql-server on my Vagrant Ubuntu 12.04 LTS virtual machine. When I did so, the setup auto-starts. I can see this in the Vagrant output: While not mandatory, it is highly recommended that you set a password ││ for the MySQL…
Sam
  • 273
  • 1
  • 2
  • 6
16
votes
2 answers

How can I completely reinstall mysql?

I had to reboot in the middle of a large data import. I only have one mysql database, which has now been corrupted. How can I completely remove mysql and reinstall it? I've tried apt-get purge mysql-server, then removing /var/lib/mysql/* and…
cwd
  • 44,479
  • 71
  • 146
  • 167
16
votes
2 answers

Will my MySQL query continue to run even if my ssh connection drops?

I've connected to a server over SSH and logged in to mysql, and asked it to run a query (the results of which are dumped into a CSV) that could take well over an hour. Although I have instructed my client to send null packets every 60 seconds to…
njp
  • 327
  • 2
  • 6
15
votes
1 answer

Why does piping `mysql` to 'tail' change the output format?

When I view the result of a SELECT with MySQL Workbench, it's correct with one single \ max@host 10:13:58: ~$ mysql -h db-master.domain.local -uuser -ppw db -e ' > SELECT > DISTINCT i.filesourceregexp > …
FaxMax
  • 716
  • 1
  • 7
  • 27
15
votes
5 answers

Suppress warning messages from MySQL in shell script but allow errors

My log files are getting dumped with following message while running shell scripts using some underlying MySQL commands. Here is the message: "Warning: Using a password on the command line interface can be insecure." To stop these messages, I am…
jagadish puvvada
  • 151
  • 1
  • 1
  • 4
15
votes
1 answer

MySQL Workbench warning when connecting to MariaDB

When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning. Is this expected? Incompatible/nonstandard server version or connection protocol detected…
MountainX
  • 17,168
  • 59
  • 155
  • 264
14
votes
5 answers

How to change MySQL 'root' password using MySQL v5.7?

Current Environment : mysql> show variables like "%version%"; +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ |…
Shivu RH
  • 143
  • 1
  • 1
  • 7
1
2 3
…
64 65