MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

1
vote
2answers
20 views

how to check every directories size use one shell command?

I want to get databases size (test,mysql,performance_schema,sakila,information_schema) [root@linux data]# ls -ltrh 总用量 32M drwx------ 2 mysql root 4.0K 4月 27 17:44 test drwx------ 2 mysql root ...
0
votes
0answers
7 views

I am running Eclipse Mars 4.5 , My CPU usage goes beyond 100% and suddenly all system stops

My system Info:: Model: Dell vostro 1015 RAM: 4 GB (2 GB extended) Processor: CORE 2 Duo Software's installed Eclipse Mars(STS and M2E plugins installed) MySql Crome Quick Heal Antivirus I have ...
-1
votes
0answers
10 views

Fatal error: Call to undefined method mysqli_stmt::get_result()

I get the following PHP error when I run my PHP code on my server, but not on my development system (localhost): Fatal error: Call to undefined method mysqli_stmt::get_result() Here's the related ...
0
votes
1answer
9 views

Trouble installing MySQL through Cygwin on Windows 10 “error while loading shared libraries”

I'm running babun(cygwin based) shell on Windows 10, and trying to install MySQL. I've ran: $pact install mysql mysqld Which executed successfully. Now, when running: $mysql_install_db I'm ...
0
votes
0answers
4 views

How to use and IF statement in PHPMyAdmin

I am using the expression below in PHPMYADMIN with the intent to use it later in a PHP/MySQL application. It gives an error relating to the DECLARE statement in line 1. I've looked at example ...
-2
votes
0answers
6 views

Connecting mysql from external or public IP

I have portforwarded the port (3306) but it still cant connect to my MySQL database. I'm trying to connect an AJAX webchat. and I have already used an account that is permitte to be used to other IPs ...
0
votes
1answer
15 views

place the MySQL libraries in the correct location

Run the following command to place the MySQL libraries in the correct location: cp /usr/local/mysql/lib/* /usr/local/lib/ and I get bash-3.2# cp /usr/local/mysql/lib/* /usr/local/lib/ cp: ...
0
votes
0answers
28 views

xampp myphpadmin and mysql server 5.7 not working together

I have MySQL Server 5.7 running on my windows 10 machine and I installed xampp 5.6. To start MySQL for phpMyAdmin I have to stop the MySQL57 service which uses port 3306 if it is already running. If ...
0
votes
0answers
5 views

mySQL ODBC driver is ANSI only

I just downloaded latest mySQL ODBC driver from here. When I tried to install it on my Windows 8.1 laptop the wizard from MSI said that it is an ANSI driver. Is Unicode version of the driver not ...
0
votes
1answer
15 views

mysql, tcp/ip, and passwords

I can't figure out why this is happening. My user has two accounts: ans@localhost for socket connections and ans@% for TCP/IP connections. My host name is valiant. mysql> select ...
4
votes
1answer
43 views

How to combine the output of two querys in MYSQL when they have non-compatible conditions

I'm looking for some assistance in adding together the output of the two following queries. They have two incompatible conditions so I'm struggling to combine them in the one query. Total Revenue ...
0
votes
1answer
15 views

Set a password to a pre-hashed value in mysql

How can I set a mysql user's password using a pre-hashed password? ===== I've got a mysql database version 5.1.73 . According to the mysql documentation, in the newer versions of mysql, creating a ...
0
votes
0answers
32 views

mysql workbench 6.3 hangs on queries on percona mysql 5.6

So I have three computers: Windows 10 with MySQL Workbench 6.0 Windows 7 with MySQL Workbench 6.3 Windows 10 with MySQL Workbench 6.3 I also have three MySQL servers. version=5.5.35-33.0, ...
0
votes
0answers
12 views

How to create password for mysql on xampp window?

I will tell you how I meet the trouble step by step. I installed xampp. Done. The I download bitnami for window. When install, it ask me mysql must running, and when i access mysql on localhost, I ...
1
vote
0answers
15 views

How to install MySQL on separate box from IIS 7

I've got two servers running Server 2008 r2. I've set up one sever as the webserver with IIs7.0, asp.net, php, nodejs, etc. And I have put MySQL and MongoDB on the other server. As best I can tell ...
0
votes
1answer
9 views

Postfix ignoring virtual alias in MySQL database, returns error “Unknown user”

I set up a Postfix email server over a year ago following this guide: https://www.howtoforge.com/virtual-users-and-domains-with-postfix-courier-mysql-and-squirrelmail-debian-wheezy. The server has ...
0
votes
0answers
16 views

How to reset root pass when the db multi-master sync replication cluster is setup in MySQL Galera Cluster

I have installed MariaDB Galera Cluster in ubuntu 14.04. Multi-master sync replication cluster is setup but we have misplaced the root password. Would really appreciate if somebody could help ...
0
votes
2answers
18 views

Excel 2016 list of options for connection to DB has suddenly reduced, (MySQL, PostgreSQL)

I work with open source dbs such as MySQL or PostgreSQL as a back-end data storage with my excel 2016. I had the full list of connections to all different kinds of dbs but they are suddenly reduced ...
0
votes
1answer
62 views

Ubuntu can't install php5-mysql

Now, before someone marks this as a duplicate, I've been looking around on the internet for the last two days and have been unable to find a resolve for my issue. All I'm trying to do is simply get ...
0
votes
1answer
13 views

This is the task manager screenshot for my server. Will increasing RAM make a difference?

The server runs XAMPP (Apache and MySQL mainly). Lately the concurrent user count has increased, and the server crawls and sputters during peak load. It only has 4GB RAM though. So, my question is ...
-1
votes
1answer
20 views

How to work in team on one VMware image?

For one project, four of us got project to work on VMware virtual image, OS is CentOS. We have to do our project in MySQL workbench, R language, and some other programs. What is the best way work ...
0
votes
1answer
12 views

dovecot isn't reading dovecot-sql.conf.ext correctly

I added the following connection string to dovecot-sql.conf.ext: connect = host=localhost dbname=<dbname> user=<dbuser> password="<password>" The following error appears in ...
0
votes
2answers
201 views

How to have MySQL entitle the machine's root user?

I'm trying to run mysqlcheck. Its failing with: $ sudo su - # mysqlcheck --auto-repair --all-databases mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when ...
0
votes
1answer
56 views

MySQL won't start

I recently tried to run a basic MySQL command. Then I got the following response: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I then ...
0
votes
1answer
106 views

MySQL package does not want to install

I am trying to install the packages mysql-server and mysql-client on Debian Jessie but I get the following output Reading package lists... Done Building dependency tree Reading state ...
2
votes
1answer
22 views

How to display key to a file using OpenSSL?

I'm a newbie at encryption so I could do with some help: I'm trying to follow a tutorial on the MariaDB website to create an aes-256-cbc key to encrypt my data at rest. The line which it tells me to ...
0
votes
1answer
46 views

Find most common capitalizations of MySQL column value

Suppose I have two MySQL tables representing items of some kind, and the text labels that are applied to those items. It's a many-to-many mapping of items to labels, represented with foreign key ...
3
votes
1answer
28 views

Initialize MySQL database as non-root and run SQL server for testing

I want to do some MySQL-specific testing and need to run a fresh MySQL database as non-root user. I am using Debian Linux and expect one could start the mysql_install_db and other commands as normal ...
0
votes
0answers
52 views

MySQL Install DB Error 13 / 1005

I am trying to programmatically install multiple mysql databases on a Ubuntu distribution server via a bash script, and I keep hitting the ERROR: 1005 Can't create table 'db' (errno: 13) each time I ...
0
votes
1answer
62 views

XAMPP and MySQL workbench [duplicate]

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
0answers
43 views

XAMPP and MySQL

Ok so I have this message error in XAMPP: 20:25:37 [mysql] Error: MySQL shutdown unexpectedly. 20:25:37 [mysql] This may be due to a blocked port, missing dependencies, 20:25:37 [mysql] ...
0
votes
1answer
42 views

restoring a mysql db via powershell

Say I have the following command: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql" -u user --password=pass dbname < backup.sql It works fine in cmd but in PowerShell I get the following: At ...
0
votes
1answer
32 views

MySql - access denied, despite GRANT ALL

What am I doing wrong here? GRANT ALL PRIVILEGES ON *.* TO 'demoUser'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ...
0
votes
0answers
11 views

How do I address the java process warning and MySql conflict while deploying Hortonworks?

I have two nodes in AWS. I got a java process warning while registering and confirming hosts. Could this warning message, issued for the name node, be ignored please? Process Issues (1) The ...
0
votes
1answer
64 views

Connect database in another computer

I cannot connect the database in another PC. I already disabled the firewall and followed the instruction in another forum. Should I install software or third party software to connect the database ...
0
votes
0answers
35 views

How can I restore a MySql database dump direct from S3?

I have a gzipped database backup stored on S3 and would like to restore it to MySql without having to first download it due to disk space constraints. I tried the two commands below but got gzip: ...
0
votes
0answers
29 views

Failed to change password to MySql (Uniform Server)

I'm trying to change the root password of the MySql and is not working, i try using the UI in normal & safe mode, the last one seems to work to change the port in Apache last time that was a ...
-1
votes
1answer
55 views

How to Find a Backdoor in a Hacked WordPress Site with Debian [closed]

I think there was a backdoor created by the hacker which allowed them to bypass normal authentication. Wordpress 4.4.2 in apache2 with MySQL I install chkrootkit, rkhunter but finding nothing! I ...
0
votes
0answers
5 views

MySQL Connection staleness

I have a Java client talking to MySQL server, When we do master/slave flipping, connections are no longer valid and JDBC stays waiting for socketRead() forever, is there a way to make server configure ...
0
votes
1answer
15 views

Vagrant box not talking to mysql on Mac through 127.0.0.1

I'm running a vagrant box to host local sites. Importantly, the mysql server is running on the Mac, not the VM. When I've set the site configuration files to use localhost the site loads properly, but ...
0
votes
0answers
50 views

“waiting for the query to be executed”

I use Excel files which pull data from MySQL via MySQL's Download Connector/ODBC (MySQL's official Excel plugin). Whenever it connects to the remote MySQL server (on Google Apps), Excel gets stuck for ...
0
votes
0answers
15 views

How do I open in Excel data exported from MySQL workbench?

When clicking to Export Data, the default format is CSV, but when the data element is text that contains a double quote and/or newline, such characters are treated by common readers (e.g. Excel) as an ...
0
votes
1answer
15 views

Setting up mysql in path on OSX so it's included everytime I open terminal

I have installed mysql on my OSX 10.11 and I want to run it from the terminal, so I need to add it to my path. I have created a .bash_profile file in my home directory with the contents export ...
1
vote
0answers
168 views

Secure wifi connection with FreeRADIUS, MySQL, EAP-PEAP, TLS

I'm trying to setup a wireless network as shown in the picture and I'm struggling how to secure it. Picture of Wifi Network: My basic question is: How I can securely store passwords into MySQL ...
-1
votes
1answer
30 views

drop database via bash with dash in database-name

I have a variable in a script with the list of folder names with dash in their names DBDIR="some directory" dbdash=`ls -l $DBDIR | egrep '^d' | grep '.-.' | awk '{print $9}'` And I want to drop ...
0
votes
0answers
242 views

E: Sub-process /usr/bin/dpkg returned an error code (1) when trying to install mysql

I'm getting the following error message while trying to install mysql on ubuntu. I've tried apt-get clean, purge, -f & uninstall but i'm heading back to the same spot. Any help would be greatly ...
1
vote
2answers
47 views

Why am I getting this MySQL database creation error?

I have a redhat linux in AWS EC2. I created a few dbs yesterday for an application. Today, I am getting an error in creating a new database. mysql -u root -p pw: xxx CREATE testdb; I get an ...
0
votes
0answers
47 views

How to find bottleneck in mysqlcluster and apache/php server?

I have setup a mysql cluster 7.3.x with 2 Datanodes,2 SQL nodes and 1 Management Node in a LXD/LXC centos 6.7 containers and a separate Apache 2.2.x/PHP-5.5 web server. The website currently serves a ...
1
vote
1answer
33 views

CPU utilization - not getting load balanced

On Ubuntu 12.04 mysqld is using 100% of the CPU and I am wondering why it is not being load-balanced among the 4 cores. Is there way to do it manually? Or should I optimize MySQL?
0
votes
1answer
13 views

MS SQL equivalent of MyISAM?

I'm trying to port an old project from Linux onto current Windows (mostly as a learning exercise). The database side is all MySQL and every table uses TYPE=MyISAM, which I've done a little reading on ...