Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysqladmin]

MySQL Administrative Operations Client

mysqladmin is MySQL's client program for performing administrative operations.

Software Capabilities

  • Check server configuration
  • Check current status
  • Create and drop databases
  • Flush Commands
    • hosts
    • logs
    • privileges
    • status
    • tables
    • threads
  • Shutdown Server
  • ping mysqld to see if it is running
  • display the processlist
  • ... and more
33 questions
18
votes
5 answers

error 2013 (hy000) lost connection to mysql server during query while load of mysqldump

I'm trying to load mysqldump and I keep getting following error: ERROR 2013 (HY000) at line X: Lost connection to MySQL server during query /etc/my.cnf: [mysqld] max_allowed_packet = 16M net_read_timeout = 30 net_write_timeout =…
alexus
  • 625
  • 5
  • 14
  • 28
10
votes
2 answers

mysqladmin not taking inline password

I am trying to set a cron job for taking backup from my slave machine. So I need to stop the slave I issued a command mysqladmin --user=root --password=test_pass stop-slave But it is throwing error: mysqladmin: connect to server at 'localhost'…
Praveen Prasannan
  • 1,546
  • 6
  • 25
  • 38
6
votes
2 answers

How does one change the default socket used by mysqladmin?

How does one change the default socket used by mysqladmin? I don't see a section for [mysqladmin] in /etc/my.cnf. It tries by default to connect to /tmp/mysql.sock, however, this is not the socket that my MySQL server uses, so I get the…
robguinness
  • 321
  • 1
  • 4
  • 9
5
votes
1 answer

mysqladmin - u root -p ping is not executing

I am getting the below error in mysql while trying to ping. i am using mysql version 5.5.37-0ubuntu0.12.04.1. when ever i use mysqladmin i am getting the below error. Please suggest how to clear this issue karthick.g.s@sumtwo:~$ mysqladmin -u root…
Karthick
  • 1,187
  • 9
  • 25
5
votes
4 answers

MySQL replication - slave update

I have a master-slave setup of MySQL. If I make any changes in the slave database... Will it mess up the sync in any way ? Will the changes get overwritten from the master during the next replication event ? Can I make above (2) option happen ?
user1249065
5
votes
2 answers

Is it safe to "FLUSH STATUS" in mysql?

We have deployed REDIS to hold some frequent query result to reduce number of connections made on Database server. We need to find out Max_used_connection after deploying REDIS. So we plan to reset mysql status variable Max_used_connection. While…
sudalai
  • 631
  • 6
  • 6
4
votes
2 answers

How to fix high memory usage of MariaDB?

I am using MariaDB(10.1.21) with following storage engines: InnoDB TokuDB Spider Engine System Configuration is : 3GB RAM Dual Core Processor I have tried pt-mysql-summary tool to identify the memory usage and it shows 90% of innodb buffer pool…
Abhishek
  • 141
  • 1
  • 3
3
votes
1 answer

Bi-directional replication for the same MySQL table

AppA stores/retrieves data from dbA.tableA AppB stores/retrieves data from dbB.tableA tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA (assuming both had 5 rows). row6 was created by AppA (say…
Rpj
  • 131
  • 1
3
votes
1 answer

Changing the administrative user on mysql from `root` to something else

Just installed mysql on Ubuntu - sudo apt-get install mysql-server sudo apt-get install mysql-client As part of the installation process, I provided a password for the root user. I can now log in with mysql -u root -p But I'd love some other user…
user2490003
  • 130
  • 2
3
votes
1 answer

How to properly stop MySQL server on Mac OS X?

I installed MySQL Community Server following instructions at http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html with the Startup Item and the MySQL Preference Pane. I can stop the server with $ /usr/local/mysql/bin/mysqladmin -u root…
qazwsx
  • 3,507
  • 9
  • 23
  • 21
3
votes
1 answer

wait_timeout kills session in SLEEP MODE or all connection ?`

Do wait_timeout session clear all running session or only sessions which are in SLEEP mode for specified seconds ?
simplifiedDB
  • 679
  • 6
  • 18
  • 36
3
votes
1 answer

mysqladmin debug writes out Current locks but PROCESSLIST and INNODB STATUS don't show any

I'm using the 1.1.8 mysql-cacti-templates to gather metrics on MySQL 5.0.77 (CentOS 5.7). Both the InnoDB Current Lock Waits and InnoDB Lock Structures graphs are charting with Cur[rent] values but there are no Locked Transactions charting in the…
HTTP500
  • 359
  • 3
  • 13
3
votes
5 answers

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : replication of test.activity table to test2 database with…
simplifiedDB
  • 679
  • 6
  • 18
  • 36
2
votes
0 answers

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the…
lalit
  • 229
  • 2
  • 8
2
votes
0 answers

MySQL 8.0 - Could not acquire management access - Administration issue

I am using MySQL Workbench for many months, it was working fine. Today, when I tried to open Server Status in the MANAGEMENT tab, below error occurred. MYSQL80 and Windows Management Instrumentation services are running. I saw some posts regarding…
vicky
  • 21
  • 1
  • 2
1
2 3