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

learn more… | top users | synonyms

0
votes
1answer
17 views

Creating a portal on Apache server that will access my MySQL database

I will start by saying I am a complete novice in this area and will be learning stuff as I go along building it. I have a database that contains data. I want to host a web page portal on Apache that ...
0
votes
0answers
27 views

MySQL Create View [migrated]

I tried to create a view for the table VIEW in information_schema. CREATE OR REPLACE VIEW Research as select * from VIEWS; But I'm getting an error like: Error Code: 1044. Access denied for user '...
1
vote
0answers
48 views

MySQL error, can no longer login as root

So I updated my MySQL and PHPMyAdmin yesterday and ever since then I cannot login to MySQL as root or any other username I have. I tried both phpmyadmin and the terminal and still cannot get in. How ...
0
votes
1answer
30 views

MySQL Workbench error for schema in database and table created from Workbench itself

Based on a database with a single simple table, created using MySQL Workbench (Community) version 6.3.7b1199-CE-64b connected to CentOS MySQL 5.1.73, I tried to use MySQL workbench to get information ...
4
votes
1answer
5k views

Installing MySQL 5.1 on Mac OS X 10.7 (Lion)

I am trying to install MySQL 5.1. I am on Lion, and when I remove all files associated with MySQL on my machine it still tells me that I have a newer version installed when I try to install it from ...
0
votes
0answers
13 views

Microsoft Web Platform Installer frozen while installing MySQL

I am trying to install Wordpress using Microsoft's web platform installer. I went to the Microsoft website and downloaded the installer, and it walked me through the installation. I was prompted to ...
-3
votes
0answers
11 views

Mysql Key C # Active [closed]

I Creating And Selling Plugins For The Game "Unturned" Using C# So i afraid my customers will sell the plugins and i think about KeyCode... Like I Create KeyCode + IP Number In Mysql Database And When ...
0
votes
2answers
3k views

MySQL ODBC driver 5.1 and Windows 7

I successfully installed the MySQL ODBC 5.1 driver for Windows: But unfortunaly it doesn't appear in the ODBC Data Source Administrator of Windows (yes, I even did a log off + log on): Why?
1
vote
1answer
6 views

Build hash of lists, as for “all tags for id” with perl dbi

I searched around the dbi docs and googled around but could not find if there was a (dbi) native way of building up a hash of lists. The closest I can think of is fetchall_hashref but that overwrites ...
0
votes
1answer
48 views

Mysql 5.7 vs 5.5: simple query takes 50 times longer to run

I have a database "algebra" with a table "questions" with 1,033,990 rows. The records have an attribute 'solved' that is INT. I have a simple query select count(*) from questions where solved = 0 ...
0
votes
0answers
33 views

How to disable secure-file-priv MySQL Ubuntu

Guys I have an application that use SELECT OUTFILE to be used as cache for another application, so, it outputs straight to /dev/shm/some/folder. As it runs on a background server, I have no issue ...
0
votes
1answer
13k views

Specified port 3306 is already in use when installing MySQL 5.6

How can I solve the problem when I try to install MySQL 5.6 and it tells me that the specified port 3306 is already in use. I uninstall my previous MySQL which is version 5.1 already and I do not have ...
0
votes
0answers
10 views

ERROR 1005 (HY000) at line 455: Can't create table 'bugzilla5.components' (errno: 150)

I ran into this problem while i was trying to import a dump file. I used the following command : #mysql -u bugzilla5 -p bugzilla5 < bugzilla.sql ERROR 1005 (HY000) at line 455: Can't create table '...
0
votes
1answer
20 views

mysqld looks for config file and data in wrong place

I have new MySQL portable located in D:\Apps\MySQL\mysql-5.7.13-winx64 and it has my.ini file in D:\Apps\MySQL\mysql-5.7.13-winx64\my.ini The content of ini file is follows: [client] port=...
11
votes
2answers
51k views

MySQL InnoDB lost tables but files exist

I have a MySQL InnoDB which has all the database table files, but MySQL doesn't see them, and isn't loading them. The problem happened because I deleted these three files: ibdata1, ib_logfile0 and ...
0
votes
2answers
11k views

Where are logs of MySQL ? Fedora

Hello I just installed MySQL on my Fedora from Source, with cmake,make,make install etc. It's working, but where can I find logs of the server? I have looked into /var/log, but there is nothing with ...
-1
votes
0answers
13 views

Suggested complements to Apache and PHP-FPM

I'm currently working on a PHP based Rest API and am trying to scale. The backend is MySQL(Maria DB). I am using PHP-FPM 5.6 and my framework is Silex. One of my main concerns is whether I need more ...
0
votes
0answers
38 views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
0
votes
1answer
7k views

Curl returns “Connection Refused” when trying to access XAMPP via localhost

I am running XAMPP (Apache, MySQL and PHP) on my Windows Vista computer. I have curl installed on my machine. When I try to curl my localhost in the command prompt, I get the following: curl -v -i ...
0
votes
0answers
10 views

MySQL dump saves only one item from tables

I'm trying to backup my MySQL db with mysqldump.exe using C:\xampp\mysql\bin\mysqldump.exe -u root -p2e970e822e1a8834203d06abb60f59ec mydb > mydb.sql I've also done cd C:\xampp\mysql\bin ...
0
votes
1answer
3k views

How to resolve Apache Service path conflict - running both Apache and portable XAMPP on Windows 7

I've got Apache 2.4.7 (Win32) running on Windows 7 and a visiting portable XAMPP on an external drive. After resolving the port issues I'm "only" down with having the "Apache/MySQL Service detected ...
3
votes
2answers
35 views

How to check every directory size using one shell command?

I want to get database sizes for - 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 ...
0
votes
0answers
18 views

“require all granted” not working with dbd auth on my apache 2.4.1

I am replacing my old apache 2.2 server with a apache 2.4.1 server. I'm in the process of testing if everything i need is still working with apache 2.4. I have some pages secured with apache auth ...
0
votes
1answer
11 views

Postfix keeps saying wrong MySQL-Syntax

I have the following Postfix config-file to map an email to itself (All credentials are fictional): user = db_mailuser password = mailuser_password hosts = 127.0.0.1 dbname = mailserver query = ...
1
vote
0answers
18 views

MySQL doesn't seem to be executing commands

I am cleaning up a lot of my DB's/Tables, and have been running into an issue. When I execute most commands which change data on a table (i.e, DELETE FROM or UPDATE), the command returns as completed ...
-1
votes
0answers
34 views

Connecting to MySQL using SQL Workbench/J with SSH tunnel

Using MySQL Workbench I can connect via TCP/IP over SSH to a MySQL server instance: https://www.namecheap.com/support/knowledgebase/article.aspx/9330/2180/how-to-connect-to-database-using-workbench-...
0
votes
0answers
18 views

MySQL doesn't shutdown cleanly sometimes

I have a fresh install of Ubuntu 16.04 LTS Server x64 in a VirtualBox VM with its provided MySQL, without any additional databases currently. Sometimes the shutdown of MySQL itself fails with the logs ...
0
votes
0answers
17 views

Service MySQL was not found on computer 'localhost' [duplicate]

I recently upgraded MySQL on my system and since then, whenever I startup my computer, I get a dialog box saying - Service MySQL was not found on computer 'localhost' When I click OK, I get ...
0
votes
1answer
34 views

Postfix setup with Dovecot, MySQL error when sending mail

So, following problem. I'm trying to setup a Mailserver loosely following this tutorial here: https://workaround.org/ispmail/wheezy/ The problem starts when I try to send my first testmail (inside ...
0
votes
0answers
17 views

checksetup.pl issue while updating bugzilla to 5.0.3

I have a problem with updating to Bugzilla 5.0.3. The problem is when I try to run checksetup.pl and this is the output that I get : Updating old chart storage format... Updating old charting data ...
33
votes
5answers
39k views

How do I stop services from starting on boot on Ubuntu?

I have lots of servers installed (Apache, MySQL, etc.), but I don't want them all to start at boot time (they drain power, and I'm on batteries most of the time). How do I configure this?
9
votes
3answers
6k views

Can't reset MySQL (MariaDB) root password

Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why. I ...
0
votes
1answer
3k views

MySQL in OS X Terminal.app — how to exit mysql command prompt but continue using the Terminal?

I type mysql and enter the mysql command prompt (denoted ~mysql) (I have ohmyzsh installed also). But I can't seem to do anything within it. No commands work. To exit, I type 'exit', and get [Process ...
1
vote
1answer
164 views

Using the same connection on AMPPS and MySQL Workbench

I am using AMPPS 3.2 and MySQL Workbench 5.2.31 on Windows 7. I have installed MySQL as a service, running "C:\Program Files (x86)\Ampps\mysql\bin\mysqld.exe" install in Administrator mode, and I have ...
2
votes
2answers
5k views

mysql (mariadb) ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked ...
0
votes
0answers
49 views

Can't connect to local MySQL server through socket - Fedora

I am a new Fedora user and I am installing ROR on my machine. But when I try to enter the following command rake db:create it shows the following errors. Can any one please tell me how can I solve ...
4
votes
2answers
22k views

How can I upgrade the MySQL version included in XAMPP?

I Want to upgrade xampp mysql from 5.1 to 5.6.10 I installed mysql server to mysql path in xampp path but didn't work for me . do you have any idea or any way to upgrade mysql in xampp ? Best Regards ...
0
votes
1answer
72 views

Openshift portforwarding to remote access MySQL database

So a followup to my other question: http://stackoverflow.com/questions/37056763/cannot-remote-access-mysql-database-of-my-openshift-mysql-cartridge I've tried port-forwarding as suggested here: http:/...
0
votes
2answers
1k views

how to insert many similar records in mysql at a time using phpmyadmin?

we know that we can insert multiple records at a time using this query: INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'), ('name2','surname2'), ('name3','surname3'), ('name4','...
1
vote
1answer
3k views

Fatal error (bad field count) while configuring Postfix

I'm using this tutorial to configure a mail server using postfix, dovecot and mysql. While configuring Postfix I have to uncomment the following lines and then restart Postfix with service postfix ...
3
votes
1answer
609 views

Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column. For example, in one ...
0
votes
2answers
77 views

Can't Locate MySQL History File [closed]

I need to find a SQL users password, I can't reset it. All I know is that there is a MySQL History file containing this information on Ubuntu 12.04
0
votes
1answer
22 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
2answers
199 views

Vagrant/Puppet/MySQL localhost issue

I have a vagrant file using puppet to configure mysql. Here is the relevant code in default.pp: class { '::mysql::server': override_options => { 'mysqld' => { 'bind_address' => '0.0.0.0'...
1
vote
1answer
985 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: /cygdrive/c/wamp/bin/mysql/mysql5.6....
0
votes
0answers
51 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 ...
44
votes
4answers
468k views

mysql how to fix Access denied for user 'root'@'localhost'

Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql |...
1
vote
1answer
34 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?
3
votes
1answer
7k views

issue on starting of mysql

I have installed "mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz" in user specified directory. I tried to start the application, but it is saying "Starting MySQL..The server quit without updating PID file (...