Client for administering a MySQL server.
mysqladmin is a client for performing administrative operations on a mysql database. You can use it to check the server's configuration and current status, to create and drop databases, and more.
Questions tagged [mysqladmin]
79 questions
2
votes
1 answer
MySQL table listed twice with different case name
I have a MySQL database table which has been listed twice with case sensitive name.
Both table names are pointing to same table, for example Admin and admin
When I checked information_schema it is listed as below:
mysql> SELECT TABLE_CATALOG, …
Dhaval Patel
- 608
- 7
- 15
2
votes
1 answer
How to solve 30 second response times because of mysql sleep?
I'm in a situation which really puzzles me, and nobody seems to know what the problem is.
I've got a website written in php/Laravel, which connects to a mysql server. If I call an api endpoint several times very fast (by clicking on a website…
kramer65
- 50,427
- 120
- 308
- 488
2
votes
2 answers
How do I dump only results of one table in a database in MySQL and replicate to another remote empty table with the same structure?
It's a long sentence, anyone knows?
user198729
- 61,774
- 108
- 250
- 348
2
votes
1 answer
Best way to get full mysql query of a specific process ID?
We have a MySQL slow query killer that kills process IDs after a specified number of seconds passes and that works fine. However we'd like in our notifications to also see the full query that was being so slow.
The problem is that while mysqladmin…
user578086
- 321
- 1
- 4
- 12
2
votes
1 answer
Revoke privileges from user in mySQL
For every new user we create in mySQL using the statement
CREATE USER newuser@localhost IDENTIFIED BY 'password';
"SHOW GRANTS" is showing only "USAGE ON *.* " privilege.
But the user is able to select,insert,.. on "test" and "information_schema"…
Roronoa
- 281
- 3
- 10
2
votes
1 answer
mysqladmin missing mysqld
I'm running percona 5.5 on ubuntu 12.04 lts. mysql is running well.
root@ip-10-252-175-58:/var/lib/mysql/data# ps -ef | grep mysql
root 2805 1 0 09:18 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 3247 2805 0 09:18 pts/1 …
user1894266
- 41
- 4
1
vote
3 answers
Problems setting database character set using mysqladmin
At shell command prompt:
mysqladmin -u"username" -p"password" --default-character-set=utf8 CREATE my_db_schema
--default-character-set=utf8 seems to have no effect and I don't understand why.
Database gets created, but character set is latin1 with…
JohnB
- 18,046
- 16
- 98
- 110
1
vote
1 answer
mariadb state wise where case clause inside view
I created below view in collaboration table
CREATE VIEW contents(
id,
title
)
AS
select
mytable.id as id,
mytable.title as title
from mytable
where mytable.owner = substring_index(user(), '@', 1);
Is there any way to detect current…
Helen
- 45
- 5
1
vote
0 answers
Is there a tool to show schema/definition changes between two dump files for MySQL?
The purpose is that if there are any table alter changes or new tables added, they should be picked up by python script set in cron and a mail should be sent.
The idea is that the script would be taking a schema-only backup using mysqldump and…
Nitesh
- 180
- 1
- 11
1
vote
1 answer
rows missing in mysql
I am trying to import data from CSV with rows 1.7 million approx in MYSQL using bulk insert after importing I get only 1.04 million rows for all the tables.
I used
select count (*) from table_name;
command to check the number of rows.
for…
A R MOHAMMED
- 57
- 7
1
vote
1 answer
How to debug "ER_HOST_IS_BLOCKED: Host 'abc' is blocked because of many connection errors" error
A quick Google search returns many results for fixing this error, but from what I can tell none of them give advice on how to discover the root cause. My understanding is that it happens whenever my application reaches a limit on the number of…
Dan Mandel
- 637
- 1
- 8
- 26
1
vote
2 answers
creating MySQL Trigger to insert into second table
I'm trying to setup a trigger to insert a sum into a second table after insert of the first table.
The tables are:
First Table Name: likes
Fields: feedid
Second Table Name: like_count
Fields: total, feedid
After insert on likes table, I need to…
FLcoder
- 43
- 5
1
vote
1 answer
linux mint mysql-server and mysql-workbench installation and setup issue
I tried to below OS installed on my laptop
Mint version 19,
Code name : Tara,
PackageBase : Ubuntu Bionic
Cinnamon (64-bit)
I have installed mysql-server using below command:
xxxxxxx:~$ sudo apt-get install mysql-server
During this installation I…
Shivraj
- 462
- 2
- 9
- 27
1
vote
1 answer
mysqld: Could not create or access the registry key needed for the MySQL application to log to the Windows EventLog
I am trying to start bin version of mysql but I run in to below error. While running from command line I am getting below trace.
D:\softwares\MySql\bin>mysqld.exe --initialize-insecure
mysqld: Could not create or access the registry key needed for…
vijay
- 11
- 1
- 4
1
vote
0 answers
Create MYSQL database in different data directory with different LINUX directory permission
MYSQL Version: 5, OS: RHEL5
MYSQL Newbie here. I am trying to create a database in a different directory without disturbing other databases. Looking up at stackoverflow, it seems that only way to do this in MYSQL5 is to create symlinks.
The default…
user3300676
- 307
- 2
- 3
- 8