I use DB 'Mysql 14.14 Distrib 5.7.24' and the OS is 'Ubuntu 18.04'  The DB server have local IP : 10.0.211.198  And For The application IP : 10.0.214.198  when I try connect form application server to db I get error in the connection but After I read it I found the mysql client change IP to Application IP as below screen    But when I try connect using telnet its successfully connected.  I try to remove db and reinstall it also try different client to connect and its same result.  Thank you
122921
I have a remote MySQL server running on x.x.x.x. And there is a database named abc.  I can do the following  mysql -h x.x.x.x -uroot use abc   But when I try to  mysql -h x.x.x.x -uroot --database=abc   I get  ERROR 1044 (42000): Access denied for user 'root'@'%' to database 'abc'   Why is that? And how do I fix it?  edit:  I have now resolved the issue by doing the following:   ssh in the box run mysql -uroot GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;   But I still don't understand why.  mysql> SELECT USER(),CURRENT_USER();  +-----------------------------+----------------+ | USER()                      | CURRENT_USER() | +-----------------------------+----------------+ | root@Maxs-MacBook-Air.local | root@%         | +-----------------------------+----------------+   mysql> SHOW GRANTS FOR root@'%';  +------------------------------------------------------------------+ | Grants for root@%                                                | +------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'root'@'%'                                 | | GRANT ALL PRIVILEGES ON `mydb`.* TO 'root'@'%' WITH GRANT OPTION | +------------------------------------------------------------------+  mysql&gt; SELECT CONCAT(QUOTE(user),'@',QUOTE(host)) from mysql.user WHERE user='root'; ERROR 1142 (42000): SELECT command denied to user 'root'@'Maxs-MacBook-Air.local' for table 'user'   Max
15912
Im trying to install mysql and I get the error: mysql_upgrade: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) while connecting to the MySQL server  After some searching, I find this is perhaps giving access to debian-sys-maint, so I did this: sudo cat /etc/mysql/debian.cnf  Then set the debian password in mysql: mysql -u root -p &lt;password&gt; GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password-here';  Then I restart: sudo /etc/init.d/mysql restart  And try and configure again: sudo dpkg --configure -a  I get the same error.
37422
I'm getting this error every few days. I won't see the error for a few days then I'll get a flurry of 20 or so all with in a minute or so.  I've been very thorough going throw my code so that I'm using this basic setup for my DB access.  try {   myConnection.Open();   mySqlDataAdapter.Fill(myDataTable);   myConnection.Close(); } Catch (Exception err) {   if (myConnection.State != ConnectionState.Closed) myConnection.Close();   throw err; }   The way I understand it this should execute my queries and immediately release the connection back to the pool but if something goes wrong with the query then I catch the excpetion close my connection then throw the error up, which eventually gets trapped at the application level and logs and emails me the error.  Even using this throughout my code I'm still running across the issue. What can I do to diagnose the root cause of the issue?
113678
I've tried other solutions, but none of them are specific to my setup. I just started using the new Linux subsystem featured in the recent Windows 10 update. I'm using WAMP x64 v3.0.6, and have successfully cloned my website and got it up and running. At the root of the Linux subsystem, I installed Drush globally with Composer, using the directions given on the .  Typing drush status returns the following when I run it in my default directory:  Drupal version         :  7.50  Site URI               :  http://default  Database driver        :  mysql  Database hostname      :  localhost  Database port          :  Database username      :  root  Database name          :  aerosphere  PHP executable         :  /usr/bin/php  PHP configuration      :  /etc/php5/cli/php.ini  PHP OS                 :  Linux  Drush script           :  /home/bob/.composer/vendor/drush/drush/drush.php  Drush version          :  7.1.0  Drush temp directory   :  /tmp  Drush configuration    :  Drush alias files      :  Drupal root            :  /mnt/c/wamp64/www/drupal-7.50  Site path              :  sites/default   But, as mentioned in the title, drush cc all returns No Drupal site found, only 'drush' cache was cleared.[warning] I assume it has something to do with adding a path to the .bashrc, but I don't know what to add. Any tips would be greatly appreciated!  My question is different from "", they're on a Mac and using MAMP, and I'm using WAMP on Windows. I've tried the solutions offered on that post, but the issue has not been resolved.  I'm obviously having issues connecting to MySQL as I get this when I run mysql command:     The program 'mysql' can be found in the following packages: * mysql-client-core-5.5 * mariadb-client-core-5.5 * mysql-client-core-5.6 * percona-xtradb-cluster-client-5.5      Try: sudo apt-get install .   So I've added these lines to my .bashrc file:  PATH="$HOME/.composer/vendor/bin:$PATH" export PATH="/mnt/c/wamp64/mysql/mysql5.7.14/bin:$PATH"   The top line was added to get drush working. I've checked multiple times, and I have the path correctly set, but it's still not working.
64782
I need to test my application when there is a change in the IP address. What should I do to change my machines IP address?  Note: The IP address for my machine is obtained automatically. It's not a static IP.
40022
How do I connect to a MySQL database using a python program?
101479
I'm trying to connect to mysql using the command  mysql -h 127.0.0.1   It comes up with the error  ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO)   Why is 127.0.0.1 being converted into my domain name, and how can I fix it?  However, it does work if I don't specify a host (and by extension, if 'localhost' is specified).  Edit: It seems it resolves to the domain name when using TCP, so it also fails when using   mysql -h localhost --protocol=TCP   Edit2: When I use skip-name-resolve I get a similar output except mydomain.com is replaced with x.x.x.x which is the public IP of mydomain.com.
15128
I'm currently developing an application using a MySQL database.  The database-structure is still in flux and changes while development progresses (I change my local copy, leaving the one on the test-server alone).  Is there a way to compare the two instances of the database to see if there were any changes?  While currently simply discarding the previous test server database is fine, as testing starts entering test data it could get a bit tricky. The same though more so will happen again later in production...  Is there an easy way to incrementally make changes to the production database, preferably by automatically creating a script to modify it?     Tools mentioned in the answers:    (Commercial)     (Commercial)   (Commercial)
103953
I'm afraid that I already know the answer to my question, but I'll ask it anyway:  When there are two MySQL DB servers, can I access data that is stored on the other server?   In other words: Can I somehow do this:  INSERT INTO table (x, y, z)    SELECT x, y, x+y       FROM [otherserver].[database].[table]   Is the answer really as short as "No"?
110884
I have a MySQL Community database on a remote server and I am trying to get Microsoft Access to read data from it. This data is sensitive. The problem is, MySQL doesn't care about the username that I give it in the .DSN file. It lets me read the ENTIRE database no matter what! How do I get it to actually check the username that I give it in the .DSN file?  edit: I'm not a DBA, I'm some intern who is over his head. Please don't assume that I know anything about anything  :)
70375
I have my database on remote Linux machine, and I want to connect using SSH and PHP functions (I am currently using ssh2 library for that). I tried using mysql_connect, but it gives me can't access (although I have granted permission) when I tried using this function:  $connection = ssh2_connect('SERVER IP', 22);  ssh2_auth_password($connection, 'username', 'password');  $tunnel = ssh2_tunnel($connection, 'DESTINATION IP', 3307);  $db = mysqli_connect('127.0.0.1', 'DB_USERNAME', 'DB_PASSWORD',                           'dbname', 3307, $tunnel)     or die ('Fail: '.mysql_error());   I got error "mysqli_connect() expects parameter 6 to be string, resource given". How can I resolve this?
5583
In my server, everytime I try to access MySQL I get the error:        Access denied for user 'root'@'localhost' (using password: NO)   when I try mysqladmin -u root -p password I get        Access denied for user 'root'@'localhost' (using password: YES)   How can I access MySQL in my Ubuntu server 12.04?
120364
I am not able to set Current_timestamp as default value. My Mysql version is 5.5.47.  Query is  ALTER TABLE `downloads` ADD `date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ;     While it is working fine on my local DB with mysql V5.6.56.
112647
in my mariadb i have replication, i tried to change the location of the binlogs by changing the configuration file as so: log-bin = /new/path/mysql-bin I also tried to change the index location as so: log_bin_index = /new/path/mysql-bin.index but every time when I restart I see that the location of the binlog files is /var/lib/mysql... i tried to check with mysqld --verbos --help | grep bin and I saw that the lob-bin parameter is mysql-bin and not what I wrote in the cnf... how to I make the MySQL to take the value of the log-bin from the cnf file? this is the cnf file of the MySQL for sure...
56834
I've recently upgraded a system from Ubuntu 14.04 to 16.04 (mysql  Ver 15.1 Distrib 10.0.36-MariaDB) and noticed root can get in without a password eg:mysql -u root is empty.   Tried setting a new pass via mysql with UPDATE mysql.user SET authentication_string = PASSWORD('supersekrit') WHERE User = 'root'; however this didn't disable the empty password. Also tried running mysql_secure_installation to no avail.  Found a  about setting the plugin field in the user row to 'NULL'. I did that, but now root cannot login at all.   I followed the link to percona in the post, which states the correct way to do this is to run the following: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';. This results in and error message -> ERROR 1064 (42000): You have an error in your SQL syntax...  Not quite sure what the correct way is to fix this. any ideas?  UPDATE: after setting the password for the root mysql account, Ubuntu 16.04 cron daemon is now throwing errors during logrotate. Looks like this issue is a rabbit hole.  I've emptied the root password for now until I can figure out what's borked with logrotate. Yeesh.  error: 'Access denied for user 'root'@'localhost' (using password: NO)'
100524
Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types:  client.frm client.MYD client.MYI    but for about 20 more tables.  I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files?
40812
What is the use of log_bin_trust_function_creators?  Also, Is the value of the parameter dynamic?  Will it change if I restart my MySQL service?