Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,937
questions
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 ...
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?
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
->
...
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 ...
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 ?
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 ...
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?
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
...
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?
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 ...
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.
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 ...
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.
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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, ...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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:
...
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: @@...
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 ...
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.
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 ...
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(): ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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.
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 ...
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 ...
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 ...
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
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 ...
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 ...
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 ...
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 ...
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 ...