mysqladmin : Administrative Operations Client

learn more… | top users | synonyms

0
votes
1answer
34 views

server running- mysqladmin error- Development Source Tree

I'm frustrated! I have installed mysql using Development Source Tree(version 5.7.5) in Ubuntu 14.04 32-bit. Starting I started mysql in safe mode using: mysqlnew@dpaks:~$ mysqld_safe & [1] ...
2
votes
1answer
122 views

mysqladmin - u root -p ping is not executing

I am getting the below error in mysql while trying to ping. i am using mysql version 5.5.37-0ubuntu0.12.04.1. when ever i use mysqladmin i am getting the below error. Please suggest how to clear this ...
0
votes
1answer
557 views

How to resolve “Error log file size is increasing in mysql 5.5” issue w/o restarting mysql

I have an Ubuntu server with MySQL 5.5 installed. In /var/lib/mysql a .err file is kept on updating with these warnings only: [Warning] IP address '234.22.11.221' could not be resolved: Temporary ...
0
votes
1answer
207 views

XML dump of MySQL database don't include foreign key constraints. What can be the reason? sqldump(.sql) file list it

I am accessing schema information of databases in XML format. I am taking dump of the database in XML format using the command below. mysqldump --no-data --xml -u root -p bakerydb > bakerydb.xml ...
1
vote
0answers
2k views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
2
votes
1answer
1k views

mysqladmin not taking inline password

I am trying to set a cron job for taking backup from my slave machine. So I need to stop the slave I issued a command mysqladmin --user=root --password=test_pass stop-slave But it is throwing ...
0
votes
1answer
272 views

Information about Disk Storage MySQL

I am trying to create an application for monitoring MySQL,in my application there's a part of monitor DISK STORAGE, so after more research I have not found how to calculate : used and free size of ...
0
votes
1answer
616 views

Can't change root password: “The system cannot find the file specified.”

I'm trying to change the root password in MySQL on my development machine (I've just installed MySQL, so it currently doesn't have a password), but it keeps failing with the following error message: ...
0
votes
0answers
25 views

Secure the jdbc and remote MySQL(windows) server connection [duplicate]

I'm a student doing a project which uses jdbc and mysql(on windows). I have an app with connects to mysql server on remote host. I just this connection to be a little secure. I found this : ...
0
votes
0answers
162 views

How to enable SSL in MySQL on Windows?

I'm a student doing a project which uses JDBC and MySQL (on Windows). I have an application with connects to a MySQL server on a remote host. To have a secure connection, I found this : ...
2
votes
4answers
527 views

MySQL replication - slave update

I have a master slave setup of MySQL and my question is that if I make any changes in the slave database: 1. Will it mess up the sync in any way 2. Will the changes get overwritten from the master ...
2
votes
1answer
222 views

Bi-directional replication for the same MySQL table

AppA stores/retrieves data from dbA.tableA AppB stores/retrieves data from dbB.tableA tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA ...
2
votes
2answers
3k views

How does one change the default socket used by mysqladmin?

How does one change the default socket used by mysqladmin? I don't see a section for [mysqladmin] in /etc/my.cnf. It tries by default to connect to /tmp/mysql.sock, however, this is not the socket ...
2
votes
1answer
805 views

How do you set the MySQL password on Mac OS X?

I've downloaded mysql 5.25 on mac os x Lion (10.7.4). I just tried setting my password in the usual way, however I'm getting an access denied error which is odd: [user@Macintosh:~] #mysqladmin -uroot ...
2
votes
1answer
7k views

How to properly stop MySQL server on Mac OS X?

I installed MySQL Community Server following instructions at http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html with the Startup Item and the MySQL Preference Pane. I can stop the ...
2
votes
1answer
105 views

mysqladmin user account not secure?

I still playing with my own DB trying to learn and saw this: I could change the root password without any problem at all... If I'm in the server I can create an algorithm to start testing password ...
3
votes
1answer
643 views

mysqladmin debug writes out Current locks but PROCESSLIST and INNODB STATUS don't show any

I'm using the 1.1.8 mysql-cacti-templates to gather metrics on MySQL 5.0.77 (CentOS 5.7). Both the InnoDB Current Lock Waits and InnoDB Lock Structures graphs are charting with Cur[rent] values but ...