Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
153 votes
7 answers
1.9m views

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

Before I screw up something, when I login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql ...
Vogelsire's user avatar
  • 1,633
73 votes
2 answers
168k views

How to remove 1000-row limit in MySQL Workbench queries?

During execution of an SQL Query in MySQL Workbench, the query is automatically limited to 1000 rows. How does one prevent the tool from imposing this limit?
Brian Hooper's user avatar
  • 1,945
56 votes
5 answers
327k views

How to exit MySQL command prompt?

I have installed MySQL. Now I am stuck inside the MySQL command prompt. I ran MySQL like this: C:\>mysql.exe mysql> Then I type in some invalid command like this: mysql> /version -> ...
Eric Leschinski's user avatar
54 votes
6 answers
300k views

How to restart MySQL?

I am running MySQL 5.1.54 and installed it on Ubuntu through the terminal using the command sudo apt-get install mysql-server I changed the my.cnf file and would like to stop and then start the ...
David's user avatar
  • 2,287
53 votes
2 answers
153k views

How to manually install Apache, PHP and MySQL on Windows?

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?
user avatar
46 votes
4 answers
67k views

how do I see which user I am logged in as in MySQL?

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log ...
nelaaro's user avatar
  • 13.5k
45 votes
6 answers
70k 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?
agentofuser's user avatar
  • 7,387
44 votes
8 answers
175k views

How to remove MySQL service from Windows

I've removed all MySQL programs from my Win7 64bit desktop and I still have the MySQL service.How can I remove it? MySQL programs I removed: MySQL Community Server 5.1 MySQL Community Server 5.5 ...
Jonathan's user avatar
  • 3,769
43 votes
4 answers
36k views

Make the table listing show entire fields

I'd like to know if a way exists to make PHPMyAdmin show entire fields in the table browsing tab. Right now I have a TEXT field and I can never read the entries in their entirety. How can I do that?
kettlepot's user avatar
  • 995
41 votes
4 answers
61k 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 ...
Morgan Touverey Quilling's user avatar
39 votes
4 answers
94k 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.
fazpas's user avatar
  • 1,603
35 votes
3 answers
146k 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 ...
Get Off My Lawn's user avatar
34 votes
3 answers
39k views

Disable MySQL startup in Ubuntu 10.04

I want to prevent MySQL from starting in Ubuntu 10.04 I have used update-rc.d -f mysql remove and confirmed that there is no link to the /etc/inid.d/mysql script from any of the rc?.d directories. ...
bryan's user avatar
  • 8,448
32 votes
2 answers
106k views

Anyway to use SSMS to connect to MySql?

I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection? I realise ...
Alex KeySmith's user avatar
31 votes
3 answers
136k views

How to drop all MySQL tables from the command-line?

Usually I open Terminal.app and connect to a remote MySQL database. Then I use this command to drop a table: mysql> drop table [table name]; But what I need is the command line to drop all ...
chefnelone's user avatar
30 votes
3 answers
26k views

Pipe gunzip and mysql to gunzip a dump and import it

I have a .gz sql dump file (example: foo.sql.gz) that i want import in my database with the classic mysql command. gunzip -c foo.sql.gz > foo.sql mysql -uroot -ppassword foo < foo.sql foo is ...
apelliciari's user avatar
29 votes
2 answers
46k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
chrisjlee's user avatar
  • 4,010
28 votes
8 answers
6k views

Can a massive MySQL data import on an SSD damage it?

I have to import quite a lot of data (~100 million rows, ~100 times) into a MySQL database. Currently, it is stored on my hard disk drive, and the bottleneck of my import seems to be the hard disk ...
christophetd's user avatar
27 votes
6 answers
127k 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 ...
d72b617c's user avatar
  • 299
26 votes
4 answers
85k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
vonhogen's user avatar
  • 2,379
25 votes
2 answers
18k views

Symlink error when installing MySQL via Homebrew

Trying to install MySQL via Homebrew. The install seems to work fine but i get an error: "Error: The linking step did not complete successfully The formula built, but is not symlinked into /usr/local ...
Asad Syed's user avatar
  • 253
24 votes
5 answers
19k views

MySQL command line color prompt

I want to add colors to the MySQL command line color prompt. I have so far in a script (database.sh): mysql -uroot -hlocalhost -A --prompt="\u@\h:\d> " I would like root to be red, @ to be blue, ...
EscoMaji's user avatar
  • 341
23 votes
1 answer
32k views

brew install [email protected] can't connect to local MySQL server through socket

I needed MySQL 5.7 installed on Mac OS High Sierra so I ran brew install [email protected]. When I do brew services list I see [email protected] started admin /Users/admin/Library/LaunchAgents/homebrew.mxcl.mysql@5....
EcomEvo's user avatar
  • 1,133
21 votes
3 answers
32k views

Cannot start mysql: InnoDB: Upgrade after a crash is not supported

I am trying to run MySQL from a Homebrew installation, but it keeps failing when trying mysql.server start. My /usr/local/var/mysql/<name>.local.err reads as so, and keeps sending this error ...
nipponese's user avatar
  • 1,114
21 votes
4 answers
98k views

What steps do I need to take to completely uninstall MySQL?

I have installed and uninstalled MySQL Server for about 100 times. Each time I reinstall the thing, it shows the same configurations, which I think cause problems. I would like to get rid of all ...
snakile's user avatar
  • 1,449
20 votes
2 answers
64k 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 ...
Diogo Paim's user avatar
18 votes
5 answers
36k views

MySQL Workbench unable to restore workspace

Whenever I restart MySQL Workbench I get the following error: That error doesn't make any sense to me. I'm able to open E:\Users\user_name\AppData\Roaming\MySQL in Explorer, so if I'm able to open ...
neubert's user avatar
  • 7,092
18 votes
11 answers
95k views

How do I split a large MySql backup file into multiple files?

I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB ... Is there a program that let's you split an SQL file into multiple SQL files? It seems like people are answering ...
Brian T Hannan's user avatar
17 votes
6 answers
55k views

systemctl enable differs from systemctl start, how?

I am running an Arch Linux (latest, up-to-date) box, and attempting to get MySQL to start at boot. With the systemd package installed I have systemctl available, and as such I can do things like this: ...
Rudi Visser's user avatar
16 votes
3 answers
45k views

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: @@...
JAVAC's user avatar
  • 263
16 votes
4 answers
35k views

Auto-restart mysql when it dies

I have a rackspace server that I have been renting to run my personal projects upon. Since I am cheap, it has 256Mb of RAM and honestly can't handle alot. Every once in a while, when there is a sharp ...
Los Frijoles's user avatar
16 votes
2 answers
29k views

View existing indexes using phpMyAdmin

Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists.
user1032531's user avatar
  • 1,651
16 votes
1 answer
9k views

MySQL Preference Pane control for MySQL installed via Homebrew

this is a repost of my question at apple.stackexchange.com I have installed MySQL via homebrew: brew install mysql. I'd like to get the MySQL preference pane hooked up to my installation of MySQL ...
Derek's user avatar
  • 281
15 votes
5 answers
23k 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(): ...
mcnesium's user avatar
  • 551
15 votes
1 answer
30k views

install mysql-client-5.7 on debian buster

I would like to know how can I install mysql-client-5.7 on debian buster using apt-get since it is not already present in Debian Buster Package Repository? Some Background info: I want to install ...
Mohsin Sethi's user avatar
14 votes
1 answer
14k views

How to expose Linux socket file from Docker container (MySQL, MariaDB, etc.) to host

Disclaimer: I am not looking for a way to configure MySQL/MariaDB to use TCP connections. I am aware of that option and the question is not about that aspect. I am having trouble binding a socket ...
Torque's user avatar
  • 359
14 votes
6 answers
19k views

MySql client for Linux [closed]

What MySql client are you using for Linux. I currently use PhpMyAdmin and the Mysql Query Browser but I would like something similar to Toad or HeidiSql that I use on windows. One with SQL code ...
Hannes de Jager's user avatar
13 votes
3 answers
17k views

How do I uninstall MySQL on Mac OS X (Snow Leopard)?

I had installed MySQL from the command line when I setup a local web server with custom modules on my Snow Leopard box. I recently discovered MAMP and its just easier to work with it than with the ...
Abhic's user avatar
  • 287
13 votes
1 answer
9k views

Why does MySQL leap from version 5.7 to 8.0?

I recently upgraded MySQL 5.7 to 8.0 via homebrew, as it warned me about not being the latest version. I was surprised to see MySQL was version 8.0 as from what I recall the latest version was 5.7. ...
Blaszard's user avatar
  • 525
12 votes
10 answers
55k views

MySQL won't start!

I'm getting this error when trying to log into MySQL from the command line: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I think this ...
Andrew's user avatar
  • 14.9k
12 votes
5 answers
30k views

Alternative to MySQL Workbench? [closed]

Is there a free alternative to MySQL Workbench? I really need a visual database designer that doesn't crash every five minutes.
MadSeb's user avatar
  • 291
11 votes
1 answer
15k views

mysql workbench visualization for schema

i have an existing database and have recently downloaded mysql workbench. I was wondering if anyone could walk me through how to navigate the workbench and how to get a visualization of the RDB. I'd ...
cfarm54's user avatar
  • 223
11 votes
7 answers
110k views

WAMP MySQL Service will not start

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn't starting.... here: and everytime I press "Start/Resume Service", NOTHING happens. I go to my.ini and put in a password.Then go ...
test's user avatar
  • 460
11 votes
6 answers
166k views

How do I start a MySQL server on Windows?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically. Now I've restarted my computer it is no longer running. What file do I need to run to get it back up ...
Shaun Wild's user avatar
11 votes
5 answers
51k 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
Mithun Sreedharan's user avatar
11 votes
1 answer
14k views

MySQL database across multiple servers

Ok, really don't know how to ask what I am looking to find out which is likely why my reading and research otherwise is yielding nothing relative per say. So what I currently have is a single MySQL ...
chris's user avatar
  • 688
11 votes
3 answers
8k views

Why can’t I stop the MySQL service on Debian?

I just tried to upgrade from debian squeeze to unstable by replacing 'squeeze' with 'unstable' in /etc/apt/sources.list. The upgrade went smoothly except for MySQL, which failed because it couldn't ...
anon's user avatar
  • 111
10 votes
3 answers
17k views

How to install the MySQL Ruby Gem on Ubuntu 9.10?

I am having a problem installing the Ruby Gem for MySQL. This is the command that I am running: sudo gem install mysql and this is the output that I'm getting: Building native extensions. This ...
Andrew's user avatar
  • 14.9k
10 votes
2 answers
45k views

How to restart MySQL with --skip-grant-tables if you can't use the root password?

I need to restart MySQL in Ubuntu 16.04 with the --skip-grant-tables option enabled, but either I don't know my root password or it isn't working. How can I set --skip-grant-tables without the ...
jcalfee314's user avatar
10 votes
4 answers
49k 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 I downloaded: mysql-5.5.18-osx10.6-x86_64.dmg I'm now at the point of setting the ...
Craig's user avatar
  • 111

1
2 3 4 5
39