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
11 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 ...
-1
votes
0answers
16 views

online service (not PHPMyAdmin) to manage relational database mySQL [on hold]

I'm a PHP developer who does relational db architecture, and am used to writing a lot of code to develop the interface/GUI (as you'd expect, SO is a good example of that). However, I have a fairly ...
0
votes
0answers
5 views

How do I modify the definition of a view in Sequel Pro?

I just switched to Sequel Pro (OSX) from HeidiSQL (Windows), and can't seem to find an easy way to modify the base query of a view. Is there something I'm missing? Or do I have to drop the view and ...
0
votes
1answer
11 views

Upgrading XAMPP, mysql tables “lost”

To upgrade from my older XAMPP to a newer one, I renamed the folder C:\XAMPP to C:\XAMPP_OLD and installed the newer version with xampp-win32-5.6.8-0-VC11-installer.exe into C:\XAMPP. Then I ran ...
-1
votes
1answer
24 views

Trouble setting up the class path for MySQL and running MySQL via terminal

Question: what is the easiest way to run the MySQL app from the terminal What I have tried: Using some stackOverFlow suggestions I have used the following commands echo $PATH, produces ...
2
votes
1answer
19 views

CentOS - Trying to backup/restore a MySQL database?

My CentOS 6 server got a server issue, so customer support took a backup of my server and reinstalled it. The backup is in a folder called /home/42406. I'm trying to find my MySQL database called ...
0
votes
1answer
35 views

Best way to implement a GUI under Debian Linux [on hold]

I'm currently using Bacula backup software under Debian Linux, all is good except the fact that it doesn't come up with a GUI. I had a look at all existing GUI out there, but none of them is what I ...
0
votes
0answers
11 views

PhpMyAdmin unaccessible from Internet

I have read about and tried other configurations of the web-based PHPMyAdmin and they don't seem to work. My environment is a CentOS 6.6 with Mysql server installed and configured before PHPMyAdmin ...
0
votes
1answer
25 views

Merging two *.db files with same tables into one *.db file

I would like to combine two mysql database files (*.db) into a single database. Both databases have the same tables. Is there an easy way to do this?
0
votes
1answer
47 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
2
votes
0answers
25 views

Logon and Logoff scripts not running

I have set SQL queries to run on logon and logoff using group policy editor. But sometimes scripts do not run. logon.bat @echo off echo INSERT INTO UPTIME(INTIME) VALUES(NOW()); > abc.sql mysql ...
1
vote
1answer
14 views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
-1
votes
0answers
17 views

How can I import latitude and longitude data into a database using Mysql Workbench?

I am currently trying to get some latitude and longitude data to import into a database using the data import wizard in mysql workbench. the problem is that the floating point values that get ...
0
votes
0answers
44 views

Arch (Linux): Failed to start verifying integrity of password and group files

I have just started installing arch and installed numerous programs, one of which is mysql. Upon starting linux, I recognized this error [FAILED] Failed to start verifying integrity of password and ...
1
vote
0answers
19 views

Find web server architecture [closed]

I am programming mostly small webs with php and mysql with 10 000 visitors per day. Now I have a web with 50 000 visitors per day and this number still increases. Visitors will load from 50 to 80 ...
0
votes
1answer
8 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
0
votes
0answers
16 views

Postfix install fails. MySQL conflict

I'm using CentOS 6, and trying to create a virtual mirror on a new server of an old one (which someone else setup). As much as possible, I want keep everything with the same version, but I've started ...
-1
votes
0answers
7 views

Cant connect to mysql ssl with compiled php (ubuntu 12) [migrated]

I have been bashing my head against a wall for a couple of days now. I just cant figure it out. I Run ubuntu 12 with plesk 12 and apache 2.2. I have compiled PHP 5.6.10 and PHP 5.6.11 with these ...
0
votes
1answer
26 views

User cannot login to MySQL from localhost with Host set to %

I installed XAMPP 5.5.24 onto another machine (OS X 10.6.8) recently. I created the DB for my application and a user for connect to it. However, I was facing the following problem: The user was not ...
0
votes
0answers
10 views

ERROR 1045 (28000): Access denied for user root [migrated]

All of my non root users can still connect and all of my websites and applications work fine. I recently discovered that I was no longer able to login as root when trying to login to phpmyadmin. I've ...
0
votes
1answer
11 views

How to change readline scroll behaviour on OS X?

I'm SSHing in Mac OS X Terminal to two ubuntu servers, then I connect to various readline-enabled shells, like MySQL or Mongo clients. Recently, it seems that somehow the scroll behaviour changed. ...
0
votes
0answers
36 views

I've to give my final year project on CD. How can I make sure it requires minimal efforts to run?

My project details: JavaEE pure JSP/Servlets MVC MySQL Tomcat Pressing ^Ron IntelliJ was easy. Now I have to give my project in a compact drive. What can I do so it does not require much effort to ...
1
vote
0answers
28 views

is there easy auto config software for setting up postfix/dovecot/mysql? [closed]

I'm really pulling my hair out on this one. I have installed all of the apps mentioned above, along with webmin and postfixadmin. Webmin gives me settings for dovecot but asks for a sql configuration ...
0
votes
0answers
15 views

Use heroku instance as a Mysql database server

I have a hosting plan which limits disk usage and I see that heroku or some other free hosting plans could come as rescue , so that I would just use their Mysql database component remotely for my ...
0
votes
0answers
23 views

MySQL Freezes System Preferences then Crashes Mac OSX Yosemite

So I'm trying to set up my Mac Mini as a webserver, OSX Yosemite. Ive installed MySQL but when I try run it from the preferences pane everything freezes then eventually crashes. The version of MySQL ...
0
votes
0answers
15 views

Change MySQL Installer for Windows update prompt period. Daily is too often

MySQL Installer for Windows - Community opens a console window about once per day to prompt the user to update a catalog and other things. A once per day prompt is very annoying. How can I change ...
2
votes
3answers
84 views

Can't include an HTML link in PHP script, but works fine as MySQL query

I'm using the following as part of a PHP script: mysqli_query($con,"UPDATE table SET description='<a href="http://123456.biz/index.php/123/321/456/*/789">text</a>' WHERE description IS ...
1
vote
0answers
62 views

Windows 7 web browser cannot access localhost

I'm using windows 7 and installed xampp, but I can't access localhost from all web browser (IE, Chrome, Firefox), it always give me "ERR_CONNECTION_REFUSED". I already googling it and found many ...
0
votes
0answers
48 views

MySql Remote. WMI connection setup does not work?

Hello i want to do a remote server on mysql that is on my computer soo i can connect to it outside network but i have a problem that i cannot solve my self. PROBLEM When i enter my windows 8 login ...
1
vote
1answer
16 views

What is the name of the daemon process of mysql in OS X?

I have just installed mysql in OS X and this code works fine: String url = "jdbc:mysql://localhost:3306/"; String dbName = "information_schema"; String driver = "com.mysql.jdbc.Driver"; String ...
0
votes
1answer
54 views

Mysql remote server with rights to WMI

I just fixed and got my MySQL running on my computer on port forwarded with all the grants. However, when I am enabling remote server Windows asks for user login information for WMI I need to enter ...
0
votes
0answers
31 views

MAC OSX Terminal (TERM)

I am using debian wheezy, I installed mysql but when I login to mysql using command mysql -u root -p and then after typing my password, I don't see any output. According to log file I am successfully ...
1
vote
1answer
19 views

Can't change MySQL/MariaDB server collation option

I am trying to change the server's collation_server variable default option from latin1_swedish_ci to utf8_general_ci by adding it into the /etc/my.cnf.d/mariadb-server.cnf config file under a ...
0
votes
1answer
129 views

Mysql port forward and access from any pc outside network

I created a application that use mysql and it will be public. I port forwarded mysql default port on my router and i want that anyone would be able to connect to mysql that is on my computer outside ...
0
votes
1answer
27 views

How to add regex aliases in Postfix when using MySQL

I need to create regex based catchall aliases in Postfix setup with MySQL. I have found examples of a mysql_virtual_alias_maps_regexp.cf with this query: query = SELECT goto FROM alias WHERE '%s' ...
1
vote
0answers
29 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
1answer
32 views

OpenSuSE 10.2: create MySQL database with “Access denied for user 'root'@'localhost'”

I have to install Wordpress on a very old OpenSuSE 10.2 web server. And for this I´m trying to create a mysql database. Unfortunately the mysql server tells me for every attempt "ERROR 1045 (28000): ...
2
votes
1answer
47 views
+50

To edit commandline Anki flashcards in MySQL

I need to make a small change in 77777 Anki flashcards, preferentially programmatically, not by using their replace tool which is not sufficient. I imported data originally there as CSV files where ...
1
vote
1answer
21 views

Is there a way to run a perl script on a windows system without having to install anything?

I have a handy perl script that I use on my linux systems to check some database information in mysql. I'd like to have a portable version of this available for Windows (specifically Windows 2008 and ...
0
votes
1answer
72 views

Connect mysql database to Ms Access directly

I am trying to connect mySql database on our server directly to an msAccess database we have. I want to be able to download data from the mysql database directly and upload it too directly. I want ...
1
vote
1answer
42 views

Windows system restore and data lost on mysql

Is it possibile that a system restore in Windows 7 system may have lost some data in mysql tables? Mysql data is typically stored in C:\ProgramData\MySQL\MySQL Server 5.6\data folder, few days ago my ...
0
votes
0answers
61 views

Changing MySQL default data storage directory gives error in CentOS

I installed mariadb in CentOS. I would like to store all my databases in a directory located in a NFS device. I have my my.conf in /etc/. My /etc/my.conf is the following one: [mysqld] ...
1
vote
0answers
22 views

Is there any chance Workbench has a case sensitive setting for Queries?

So I have been using MySql workbench for an online database I was able to set everything up but to my suprise and my boss' amazement, Workbench was actually case sensitive. We wrote two select ...
0
votes
0answers
22 views

Configuring a centralized rsyslog server with MySQL database, gathering events from multiple servers

I'm trying to configure my rsyslog server to collect logs from many servers and write them to a local database. The problem is, the server writes the data to the DB as local (host, ip, etc) I'm ...
0
votes
2answers
15 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
0
votes
1answer
27 views

MYSQL Connector J in Ubuntu

I'm relatively new to Ubuntu and am developing an application using MySql Server. My question is, where do I put the file? I know in Windows the connector goes in the 'lib' file of the project. Does ...
1
vote
0answers
29 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
0
votes
1answer
48 views

centos7 not installing mysql

I've installed centos7 recently, but, when I am trying to install Mysql using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
0
votes
1answer
24 views

How to change ports in UniserverZ and/or Uniserv?

I'm asking this because every single time i need to update the program, the configuration file is updated too and the port must need rechanged, but my question is honest because: 1) When i try to use ...
1
vote
1answer
27 views

Does windows 7 stop services/processes if low on ram?

I am having an issue with some customers where a service is stopped (Mysql). Mysql uses a fair amount of memory and I am wondering if windows decides to stop it when low on ram. Is there any other ...