Stack Overflow
Stack Overflow

Questions tagged [mysqladmin]

Client for administering a MySQL server.

mysqladmin is a client for performing administrative operations on a database. You can use it to check the server's configuration and current status, to create and drop databases, and more.

Useful Links

79 questions
127
votes
25 answers

MySQL root password change

I have been trying to reset my MySQL root password. I have run mysqld_safe --skip-grant-tables, updated the root password, and checked the user table to make sure it is there. Once restarting the mysql daemon I tried logging in with the new root…
nick
  • 1,668
  • 2
  • 11
  • 14
110
votes
3 answers

Is there a way to pass the DB user password into the command line tool mysqladmin?

I currently use the following but it ALWAYS prompts me to manually type the password. Is there any way to pass it in on the command line when launching the executable? mysqladmin processlist -u root -p
Ethan Allen
  • 13,099
  • 22
  • 89
  • 175
54
votes
1 answer

Difference between mysql, mysqladmin, mysqld

Can someone give me a clear explanation of the differences between mysql (command line tool), mysqladmin (client tool for performing administrative tasks) and mysqld (mysql server).
Preom
  • 1,663
  • 3
  • 15
  • 19
24
votes
4 answers

ERROR 1044 (42000): Access denied for 'root' With All Privileges

I have strange error. I am logged in local Mysql as root via command line. After creating database: create database some_db; Then giving privileges to some user: grant all privileges on some_db.* to some_user@'localhost' identified by…
latvian
  • 2,881
  • 9
  • 30
  • 57
23
votes
2 answers

Why MySQL connection is blocked of many connection errors?

As you can see I have a problem on a database connection. It gives me this error: ...is blocked because of many connection errors I searched some answers but I couldn't solve my problem. I don't know if I gave all the information that you need,…
Nick
  • 303
  • 1
  • 3
  • 10
14
votes
2 answers

mysqladmin: connect to server at 'localhost' failed

Today (2015-05-02) I upgraded my Linux system via apt-get update and apt-get upgrade whereas mysql, mysqladmin and a lot more packages have been updated. The mysql-server-5.5 runs and I can login and do all the typical database operations but when I…
udgru
  • 997
  • 4
  • 12
  • 23
7
votes
2 answers

mysqli php random connect error

I am receiving the below error randomly from the php backend jobs and php web page logs. Have a app server which runs php backend jobs and php webservers. Both connect to the same database server. Using php mysqli object oriented library for…
Arav
  • 4,291
  • 20
  • 64
  • 112
7
votes
2 answers

SQL: Interrupting a query

I've worked on a project using a proprietary non-SQL DB where queries could be interrupted and in the codebase there were quite some spots where that functionnality was used and made perfect sense (for example to stop a long running query that gets…
NoozNooz42
  • 4,113
  • 6
  • 28
  • 51
7
votes
1 answer

mysqladmin ping error code

Mysqladmin ping returns 0 even with a password failure, a thing that mysqlclient doesn't. Is this a mistake from Mysqladmin Developpers? I don't understand why Mysqladmin is asking for a login/password because it returns 0 even if you don't specify…
Arka
  • 267
  • 1
  • 6
  • 16
5
votes
2 answers

MySQL root@localhost, root@127.0.0.1 and root@::1 have different passwords - is it normal?

After setting password with this command: mysqladmin.exe --user=root password I see 3 rows in user table for "root" user: http://i.stack.imgur.com/Y4Rkd.jpg and root@localhost has password, while root@127.0.0.1 and root@::1 do not…
i123
  • 51
  • 1
  • 2
5
votes
2 answers

difference between opened files and open files in mysql

In the below status i have opened files count to be '95349'. this value is increasing rapidly. mysql> show global status like 'open_%'; Open_files = 721 Open_streams = 0 Open_table_definitions = 706 Open_tables …
siva
  • 436
  • 3
  • 7
  • 19
3
votes
1 answer

Cannot set password for MySQL root user

I am trying to get MySQL running on my localhost. This never happened to me before, but upon installation sudo apt-get install mysql-server did not ask me for the initial password. After searching for answers to "reset" my password and battling…
Digital Ninja
  • 2,496
  • 3
  • 18
  • 37
3
votes
1 answer

mysql user last login / access date time

During in a audit task, I am going to delete few mysql users. Before delete I want to check, when the last time these user access the database server. I want to know if we have this information stored in information_schema or mysql databases. If not…
Faizan Younus
  • 729
  • 8
  • 13
3
votes
4 answers

Whats the most efficient MySQL column types for this data?

I have several tables with some pretty standard data in each. Can somebody help me optimize them by telling me the best column types for this data. Whats beside them is what I have currently. Number (max length 7) --> MEDIUMINT(8) Unsigned Text (max…
Derek
  • 33
  • 5
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
  • 39,074
  • 90
  • 255
  • 436
1
2 3 4 5 6