Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysqladmin
Search options answers only
not deleted
user 877
MySQL Administrative Operations Client
1
vote
Accepted
Information about Disk Storage MySQL
Here is a query I use to get all the used space of MySQL for all storage engines:
SELECT
IFNULL(ENGINE,'Total') "Storage Engine",
LPAD(CONCAT(FORMAT(DAT/POWER(1024,pw1),2),' ',
SUBSTR(uni …
- 184k
1
vote
Can't change root password: "The system cannot find the file specified."
Use double quotes
mysqladmin -u root password "Pe%8XiduwOqdZ<ZFE5!"
TECHNIQUE #2
root@localhost has no password. …
- 184k
2
votes
How to properly stop MySQL server on Mac OS X?
I actually prefer your mysqladmin method for a reason...
In Linux, I have seen the mysql.sock (the socket file) file just up and disappear without warning. … Users with shutdown_priv='Y' can only be done from mysqladmin. …
- 184k
0
votes
Accepted
mysqladmin user account not secure?
Before you continue playing with mysqladmin, you need to make sure your installation is not intentionally giving away access.
For starters, can you login to mysql like this? … user='';
FLUSH PRIVILEGES;
Now, locate all users with no password with this:
SELECT user,host,password FROM mysql.user;
If any users have no password, you can issue new passwords for user using mysqladmin …
- 184k