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
2answers
32 views

phpMyAdmin cannot login - keeps asking for credentials

I have phpmyadmin on my Arch linux box, it is running, so is apache with php and mysql. When I go to http://localhost/phpmyadmin/, it shows the usual login prompt. However, no matter what I enter, ...
0
votes
0answers
5 views

Error while trying to create an album in MySQL in Trovebox

When trying to create a new album in TroveBox I just get an simple error message in the ui notifying me that it failed. No information is in logs from Apache and MySQL. The current user can write in ...
0
votes
0answers
5 views

MySQL is installed but it is not detected as being installed

I think one of my friends had installed mySQL on the RHEL 6.2 OS I'm working on, but when I tried running it or uninstalling, it says the rpm is not installed, and when I try installing the rpm, it ...
4
votes
3answers
401 views

Is there a way to build my own “Portable” Windows AMP (Apache, MySQL, PHP) Stack?

I know there are things like XAMPP thats portable, but it does not use latest version of the software, can I build my own? I prefer portable stuff as they don't require installs, won't be affected ...
1
vote
4answers
7k views

Removing MySQL completely on Linux

I'm fairly new to Linux, when I first installed MySQL it was during an LAMP setup on personal machine with a Ubuntu Setup. ATM, I'm trying to get a fresh, clean install of only MySQL. I've been to ...
3
votes
3answers
3k views

phpmyadmin symlinks error after ubuntu upgrade

After the upgrade of my ubuntu server to 13.04 my phpmyadmin is no longer reachable. the browser reports 500 (internal server error) and in the error.log it says: PHP Fatal error: require_once(): ...
-1
votes
0answers
18 views

where to create database for a website [on hold]

I have started designing a website from scratch in notepad. I want to create database containing the login information, etc. for my website, but I don't know where! I know how to create and connect to ...
-1
votes
1answer
16 views

SQL remove everything behind a comma in string [on hold]

I have a mysql table storing some data. One column stores strings containing a comma. I want to get rid of everything (including the comma) in this string and save it, but I don't get it to work. I ...
1
vote
1answer
16 views

Will re-installing MySQL remove or delete existing databases?

If I reinstall MySQL, without removing the actual MySQL installation, would it rewrite all files without deleting my databases? My problem is my mysqld is broken, due to the fact that I accidentally ...
0
votes
1answer
13 views

How to get access to MAMP mysqldata base when 1045 access denied error is posed?

Been stuck for a few days now. I've been SCOURING google for solutions and have tried many things. Basically I was editing my users in phpMyadmin and I think I erased the user 'root' which is my ...
0
votes
2answers
31 views

Trovebox (OpenPhoto) setup hangs/fails at final step 3

I've been following the install instructions found here about how to install and configure Trovebox on a Ubuntu server running Apache: Ubuntu 14.04 LTS Apache: 2.4.7 MySQL: 5.5.37 PHP: 5.5.9 ...
0
votes
0answers
7 views

InnoDB O_DIRECT on NTFS external drive

I have a MySQL database with a table that has about 170 mil rows. I have it partitioned into 32 partitions with hash(id div 10000000). I created and imported the rows and then moved the data to an ...
-1
votes
3answers
2k views

mysql access denied for 'root'@'name of the computer'

I am getting this error everytime im trying to connect to my database Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root'@'name of the computer' ...
2
votes
4answers
457 views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
0
votes
1answer
22 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
0
votes
0answers
16 views

Mysql resolving 127.0.0.1 to hostname [duplicate]

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 ...
0
votes
5answers
48 views

Mysql resolving 127.0.0.1 to hostname

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 ...
0
votes
2answers
69 views

Upgrade Failure in FreePBX Installation

I'm building FreePBX 2.11.0.25 from source over Asterisk asterisk-11.9.0 (also built from source) on a Ubuntu 14.04 64-bit server installed on a VMWare VM. During installation I had an error that ...
0
votes
0answers
62 views

Is there anything here to stop access to 3306?

I am trying to work out why a script on my online server cannot access MySQL to get playlist data and display it. I have checked all I can and it is not the script, as many others are using it with ...
0
votes
3answers
7k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I ...
0
votes
0answers
11 views

Mysql Failed to started after mysql dump restore process

i tried to restore a db backup to a newly created database, suddenly its starts showing error. Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock so i checked ...
0
votes
1answer
87 views

Error starting MySQL server through commandline on Mac OS X 10.9

I am installing MySQL manually on my Mac and during that I started MySQL through command line using this command $ /usr/local/mysql/support-files/mysql.server start Starting MySQL . ...
0
votes
1answer
62 views

Mysql server won't start after Mavericks upgrade

I am unable to start MySQL server after upgrading from OSX 10.8.5 to 10.9.3 prompt: sudo ./support-files/mysql.server restart ERROR! MySQL server PID file could not be found! ...
1
vote
1answer
2k views

MySQL ERROR 2002 (HY000) on CentOS 5

I have problem with starting up mysql. When I type service mysql start All I got is ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock' (2)** ...
0
votes
0answers
12 views

Having trouble with MySQL and 3306

I have XP Pro, Netcomm NB304N Modem and ADSL out to web. Web page is on our shared server website. MySQL is installed, 3306 is shown as open and accessible by Port Forwarder yet I cannot get a script ...
0
votes
1answer
2k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
3
votes
1answer
23 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
-1
votes
1answer
25 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
1answer
32 views

Can't login to local phpmyadmin

Hy, I've just installed MySQL and PHPMyadmin on my OS X Maverics, following this link: http://www.coolestguidesontheplanet.com/downtown/get-apache-mysql-php-and-phpmyadmin-working-osx-109-mavericks ...
-2
votes
1answer
14 views

WAMP after MySQL

I had previously installed Developer default using MYSQl notifier. I have recently installed WAMP. Do I need to remove all connectors, documentation etc of the MySQL components, or only MySQL server, ...
9
votes
6answers
43k views

Install MySQL 5.5 on Ubuntu 10.04

How to install the MySQL 5.5 on Ubuntu 10.04? apt-get install mysql-server is only allows to install 5.1.41.3ubuntu12
0
votes
1answer
64 views

Unknown SQL server host error in phpMyAdmin after switching php versions in WAMP

I've installed Wamp Server 2.2, which includes php 5.3.13, Apache 2.2.22 and MySQL 5.5.24. Then I installed php 5.2.4 using the WampServer2-PHP524.exe extension found here on SourceForge. When I ...
14
votes
3answers
14k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
3
votes
3answers
7k views

Mysql Fail to start

I'm running a Ubuntu 12.04 LTS Virtual Machine. Last week, the VM stopped unexpectedly now mysql will not start on the VM. These two events may be related, they may not be. When I try to connect: ...
1
vote
1answer
1k views

MySQL server 5.5 on CentOS 6.5 error: “mysqld: unrecognized service”

I am using CentOS 6.5. I installed MySQL Server 5.5 from a .rpm package (downloaded from the official MySQL site) using the default .rpm installer. I also installed MySQL Client package the same way. ...
0
votes
0answers
12 views

Find the reason why mysql root password is reset at ever system boot

Every time when I restart the server, booting the system I have to the following error: database error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I can ...
0
votes
1answer
2k views

Curl Returns “Connection Refused” when trying to access 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
1answer
37 views

Database tables exist but MYSQL says they don't

When I log into MySQL and SHOW TABLES, I see a list of the tables. But, when I run a query against any of them, I get the message: ERROR 1146 (42S02): Table 'dbname.tablename' doesn't exist If I ...
2
votes
2answers
791 views

Cannot Install MySQL on Windows 7

I get the error: This installation package could not be opened when trying to install MySQL on Windows 7. Everything else installs fine. I have full administrative rights. Why does this ...
2
votes
2answers
2k views

Can I use MySQL Workbench to create data?

The MySQL Workbench seems to be a nice tool for create database schemata. When I export a model, there is a checkbox for "create insert statements". Thus, it should have an option to fill one's ...
2
votes
3answers
5k views

MySQL Workbench, start with auto commit off

I'm running MySQL Workbench 5.2, and whenever I make a connection to a database auto commit is toggled on. Is there any way to have the default behavior be changes so that auto commit is toggled off, ...
0
votes
2answers
26 views

Moving /tmp to a different mounted drive

I've mapped my MySQL datadir to a different (and bigger) disk with 900GB [root@web ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda1 40G 24G 14G 64% / tmpfs ...
0
votes
1answer
42 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
0
votes
2answers
299 views

MySQL: How to delete single table that is connected via foreign key?

I am generating a database schema via Java and want to drop only the tables I made changes to, in order to spare me from entering all the data again (or importing it from a manually updated dump). ...
1
vote
1answer
4k views

Installing MySQL 5.1 on 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
1answer
25 views

One database on Linux and Windows

I want to use MySQL database on my Ubuntu installation as of Windows 7, It should be dynamically, I mean when I change data in database on Ubuntu it should save also on Windows too. I've already ...
2
votes
1answer
3k views

Error message: sudo: mysql_secure_installation: command not found

I'm trying to learn PHP and I'm just in the process of installing apache,msql and PHP. I'm on a mac osx 10.7.2 Processor 2.26 GHz intel core 2 due I downloaded: mysql-5.5.18-osx10.6-x86_64.dmg ...
1
vote
7answers
9k views

XAMPPErrorDomain error 1 for changing MySQL data dirs

I tried to move my mysql data dir from one disk to another, I modified the datadir parameter in my.cnf, but when XAMPP, and more precisely, MySQL starts, this error is displayed and MySQL doesn't run. ...
0
votes
0answers
12 views

Inconsistent slow DB connect times [on hold]

I have an app that shows significantly increased load times every 5 minutes. We use New Relic and I've been able to identify that every slow request is due to our DB connect functions. I've looked ...
3
votes
2answers
8k views

How Do I Reset My Root Password on MySQL on a Mac?

I'm using SequelPro (http://www.sequelpro.com/) and I would like to know how to reset my root password. I'm trying to log in as host: localhost username: root password: (BLANK) But I keep ...