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
0
votes
1 answer
MySql Admin User lost Privileges
On PreProd - MySqlServer Admin account lost the privileges which was all good yesterday.
When ran show grants for xxxxxadmin;on Dev its resulted as
On Pre-Prod (which was same as Dev)
There is no other admin account to log into the server. Is…
Sreedhar
- 29,307
- 34
- 118
- 188
0
votes
1 answer
mysqladmin Access Denied when using -defaults-file=/etc/mysql/debian.cnf
While using mysqladmin --defaults-file=/etc/mysql/debian.cnf, mysqladmin fails with following error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
But if I try to login…
SiddheshNan
- 90
- 1
- 9
0
votes
0 answers
How to insert input to mysqladmin on command line?
I'd like to automatize the initialization process of the MySQL. At the end of the initialization process, I need to change the password of the database, using mysqladmin -uroot password. But to automatize this, I need to type a new password manualy.…
wurikiji
- 327
- 3
- 12
0
votes
1 answer
Script the a complete Sybase database
We are using Sybase 8 and Sybase 16 databases in our current project. I have a requirement where I need to script the a complete Sybase database(with some built-in data in certain tables) with Sybase scripting tools. For example, if I run a Sybase…
MgmtTech
- 11
- 3
0
votes
1 answer
"service mysql reload" mysqladmin: connect to server at 'localhost' failed BUT restart works fine
Reload'ing mysql fails. But both restart and status work fine.
Any ideas on how to fix/troubleshoot so reload works?
On restart it also takes about 20 seconds to restart like something is timing out before it finishes. I tried creating a local…
Kyle Anderson
- 1,820
- 5
- 21
- 29
0
votes
2 answers
Php, mysqladmin. How to redirect to the index after user logged in with his username, without displaying Notice: Undefined index: from the start
I want to display the username of the user who logs in while redirecting to the index.php However, when I run the index(Homepage) without logging in. I don't want it to display an error Notice: Undefined index: username.
index.php…
dalmatian
- 19
- 3
0
votes
1 answer
MySQL root password not in mysqld.log
I'm trying to install MySQL 5.7.18 on Fedora 25.
I'm following this link: https://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/
I get stuck on here on step 5: grep 'A temporary password is generated for…
Chris Woo
- 1
- 2
0
votes
3 answers
MySQLAdmin replace text in a field with percent in text
Using MySQLAdmin. Moved data from Windows server and trying to replace case in urls but not finding the matches. Need slashes as I don't want to replace text in anything but the urls (in post table). I think the %20 are the problem somwhow?
UPDATE…
TIJ
- 1
- 2
0
votes
1 answer
Switching database connection in mysql
Here my problem :
I have two mysql databases directory and I want to use one after the other.
The only way that I have actualy found, to switch from one database to the other, is to shutdown the mysql daemon and to start it again pointing to the…
MonkeyJLuffy
- 195
- 3
- 15
0
votes
0 answers
Get error Access denied for user 'root'@'localhost' (using password: NO) when setting Wordpress on amazon ec2
I have a problem when I setting up wordpress on amazon ec2, but I'm getting an issue about 'Access denied'.
[root@ip-172-31-25-142 ec2-user]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:…
Theo
- 63
- 4
0
votes
1 answer
How do I change the temporary root MySQL password using a bash shell script?
I need to change the temporary root password that is created when the MySQL daemon is started. The problem is that the temporary password has some weird characters (e.g. like a left/right parenthesis) that needs to be escaped. Now, there are several…
Jane Wayne
- 8,205
- 17
- 75
- 120
0
votes
1 answer
PHP script to search MySQL database
I have a script that is supposed to return values from a mysql tables based on search inputs. This script is composed of two files.
search.php
Tj Keel
- 79
- 4
- 12
0
votes
1 answer
How do I change/set mysqladmin pw from command-line in Win 7?
I tried to do:
mysqladmin -u root password
But I got the following error:
mysqladmin: connect to server at 'localhost' failed.
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
What could be causing this?
This is a…
marcamillion
- 32,933
- 55
- 189
- 380
0
votes
1 answer
mysql innotop not working - use of unitiialized value
Installed innotop 1.10.0 on centos7 mysqlversion is 5.7.12. When i run innotop in centos server and option T selected it gives me the use of unintiaized value error how do i fix it.
WThread Waiting Query WWait BThread BRowsMod BAge BWait …
Arav
- 4,957
- 23
- 77
- 123
0
votes
1 answer
using triggers, mySQL version 5.5
I have 1 table with an id (auto increment), username, email, icon, comment, rating, date (on update current_timestamp, left empty as now() does not function so must pre-date) and counts.
What I want to do is set up a trigger for every insert (count…
Alex
- 71
- 10