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.

987 questions
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
10
votes
4 answers

error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory

So I'm running a program a college wrote on debian. When I do, the following error arises: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory I tried installing the following…
Agustin Barrachina
  • 231
10
votes
1 answer

How can I fully remove a tablespace from MySQL?

I have a MySQL database called camera_main_live, which I administer using Adminer. It is, to all appearance, empty. So when I want to add some content, I begin by running this script (with Adminer set to stop on error): DROP TABLE IF EXISTS…
TRiG
  • 331
5
votes
1 answer

I get the Error "mysqld dead but pid file exists"

I get the Error mysqld dead but pid file exists This happens every couple of hours. If I restart it works fine and then goes down again. [root@ip-10-0-0-149 log]# df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda1 7.8G 1.5G 6.3G 19% / …
Mario
  • 51
3
votes
2 answers

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

I'm running on an Ubuntu 19.04 distro and have a Dockerfile which when we reach step 7; Step 7/11 : RUN (/usr/bin/mysqld_safe &); sleep 5; mysqladmin -u root -proot create wordpress we get; 2019-10-09T12:18:34.365421Z mysqld_safe Directory…
cookie
  • 222
  • 3
  • 8
  • 20
3
votes
0 answers

How do I decrease the amount of fsync that mysql does?

I am trying to import a database into a slave server. The process is being slowed because mysql calls fsync at a crazy rate. The jbd2/dm-0-8 runs at 80 - 99 % continuously but the throughput is quite low. It was running at a few kb/s till I…
Wayne
  • 31
2
votes
1 answer

Create multiple databases in one command line?

Can this command be scripted? $ mysqladmin -u username -p create databasename I'd like to do it for multiple names all at once? Also I'd like to then set permissions for all of them at once as well. I'm not sure how to do this?
cea
  • 1,543
2
votes
1 answer

How to copy the whole MySQL DB between two servers?

There is a very good connection between the two machines (MySQL 5.5.28): mysqldump -u root -p'password' --all-databases | ssh root@SERVERNAME mysql -u root -p'password' --all-databases So AFAIK this oneliner is like taking a MySQL dump on server#A…
gasko peter
  • 5,514
2
votes
1 answer

Sandbox-HDP The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

I installed MySQL and the MySQL community server on my Hortonworks HDP. I started service and tried to change password /usr/bin/mysql_secure_installation Securing the MySQL server deployment. Connecting to MySQL using a blank password. The…
Richard Rublev
  • 309
1
vote
0 answers

Mysql user privileges : Only CREATE table

I am trying to create a user who will be able to manage all databases without the right to CREATE and DROP databases. I have been using the following link : http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html#priv_create GRANT SELECT,…
Hugo
  • 2,439
1
vote
1 answer

MYSQL not starting

Here is a my error log file [localhost:local/mysql-5.5.15-osx10.6-x86_64/data] root# sudo localhost.err localhost1.err 130911 14:16:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 130911 14:16:25 [Warning] Setting…
user46953
  • 11
1
vote
2 answers

How to view a list of previously run MySQL queries in a live feed format?

How do I view the last run queries in MySQL in a live feed format? I want to leave my terminal window open and just have MySQL queries pop up on the screen whenever something is run. I know I can do it with the tail command, but I'm not sure where…
Patoshi パトシ
  • 1,775
1
vote
0 answers

How can I reset my lost MySQL root password?

I created a new DigitalOcean droplet and stupidly deleted the env file in the root to clear it out so I could setup my application. The only recorded place that had the root user's password. I'm trying to reset said password but literally none of…
user525249
  • 11
1
vote
1 answer

Why does mysql-server installation not request root password from me?

I have recently ran into a problem, I was trying to change root password, which I forgot, but it seems that I somehow managed to completely break the mysql service itself and due to the fact many of my other services had problems connecting to the…
Arty
  • 11
1
vote
2 answers

How to monitor the number of rows inserted per second and per minute into MySQL db

I have a running script which is inserting data into a MySQL database. I want to know how many rows are getting inserted per second and per minute. If the count of rows inserted per second or per minute goes beyond a certain count, I need to stop…
The Dark Knight
  • 2,254
1
2 3 4 5