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
1
vote
1 answer
mysql 5.7.10 create user issues
Installed latest mysql version 5.7.10 . When I tried to create new users it's giving me error. Tried different ways provided in the mysql documents. but it's still giving me error
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY…
Arav
- 4,957
- 23
- 77
- 123
1
vote
1 answer
Is there a way to have .my.cnf settings for mysqladmin and mysql standard console?
My Ubuntu Linux development machine I have the following ~/.my.cnf file which is a great time saver when connecting to mysql from the command line.
[client]
auto-rehash
safe-updates
host = localhost
user = root
password = mysql
prompt =…
Andy Fusniak
- 1,548
- 1
- 17
- 28
1
vote
0 answers
Mysqladmin exit codes
Is there a list of exit codes for mysqladmin commands? I checked the documentation but apart from ping command, it does not contain information about exit codes.
I need to know the exit codes of create, drop command as I need to automate few…
shrivb
- 1,511
- 3
- 15
- 20
1
vote
1 answer
mysqladmin: Unknown command: 'status;'
My problem :
C:\Users\Dom>C:/xampp/mysql/bin/mysqladmin -uroot status;
C:/xampp/mysql/bin/mysqladmin: Unknown command: 'status;'
I want to see status my mysql connection.
How to fix?
Michael Phelps
- 3,451
- 7
- 36
- 64
1
vote
1 answer
Block Host Name in Mysql
I want to block a remote server to access MySQL and want to get this error "blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" .
How do i block user in such manner in MySQL ? DO i need to hit the server for connection…
Vivek
- 11
- 4
1
vote
2 answers
MySQL new user PRIVILEGES not working
I created a user to only select/Read data from MySQL but I can still drop tables from database.
what is wrong in this SQL script.
create user 'test'@'%' Identified by 'test!';
grant SELECT ON * . * TO 'test'@'%';
FLUSH PRIVILEGES;
Developer
- 817
- 2
- 16
- 28
1
vote
0 answers
/usr/bin/mysqladmin: connect to server at 'localhost' failed
When type stop command ( /etc/init.d/mysql stop) to mysql server I'm getting following error:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'…
Index
- 676
- 1
- 10
- 27
1
vote
3 answers
Rake seems to be hijacking MySQL
So if I type mysql -u root I'm supposedly logged in, however upon trying to create or access a database I get this lovely error: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test1'. I haven't the foggiest idea why after…
Zachary J Rollyson
- 153
- 9
1
vote
1 answer
MySQL user creation date, modified date
I have a question to all you MySQL experts out there: Is it possible to see when a user was created in MySQL? Let's say I create a user called 'monty':
CREATE USER 'monty'@'localhost' [...]
how can I see when I created this user? Is there also a way…
Tamas
- 10,953
- 13
- 47
- 77
1
vote
3 answers
mysqladmin to set initial root password fails in script but works in shell
I am trying to do this as part of a startup script (that runs as root) on an EC2 instance
# mysqladmin -u root password mygreatnewpassword
To debug this I echoed the entire command to the log and it's correct. I did a 'ps ax' before the command in…
JK Scheinberg
- 11
- 1
- 5
0
votes
1 answer
hash value different between mysqladmin and password() funciton
I've compiled & installed a mysql-5.1.59 on a x86_64 linux server.
First I set root password in cli and login:
$ bin/mysqladmin -uroot password 'somepass'
$ bin/mysql -uroot -p 'somepass'
mysql>
Login succeed!
Then I created a user using SQL…
Dongying
- 3
- 2
0
votes
1 answer
Checking when a MySQL server is ready to run queries without interrupting them
I'm using the Percona Docker image, purely for local testing purposes (5.6 because that's what I need to test against).
I want to run an initialization script when the server is ready. I've tried two things so far that have been mentioned in other…
notablytipsy
- 387
- 1
- 4
- 19
0
votes
0 answers
Is there a way to change MySQL root password during re-installation (Windows 10)?
I have forgotten my password for my MySQL server and it won't let me configure my MySQL server as I don't know the root password. MySQL is not currently installed on my machine ; I am trying to re-install it. Does anyone know how to change the root…
Ahmed Dhayib
- 1
- 1
0
votes
0 answers
BLOB/TEXT column 'bought_furniture' can't have a default value
Hello so I've exported this from a server where it worked perfectly fine and I looked up this error
#1101 - BLOB/TEXT column 'bought_furniture' can't have a default value
but can't find any useful sources of fixes, the database is only having a…
Tarvik
- 1
0
votes
1 answer
Using Roles in MySQL Azure - Privileges Issues on Admin Account
Provisioned MySQL Sever on Azure.
While provisioning created Server Admin Login Ex: mySqlAdmin
Now we are trying to start creating Roles and assigning Users to Roles.
Logged into SQL Work Bench with Admin Account ( mySqlAdmin ), which was created…
Sreedhar
- 29,307
- 34
- 118
- 188