Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
68
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 ...
- 1,633
1
vote
1
answer
4k
views
Apache+PHP+MySQL for latest Windows 10 [closed]
I tried to setup XAMPP and WampServer, as well as manually downloading and setting up the latest installers for Apache+PHP+MySQL on Windows 10, but everytime time I get different errors. Can anyone ...
- 459
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.
...
- 8,448
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 ...
- 299
5
votes
2
answers
2k
views
Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?
If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute ...
- 53
5
votes
2
answers
5k
views
How to automatically restart MySQL and MongoDB when being unresponsive?
I’m running a simple development server (Ubuntu) on which MySQL and MongoDB sometimes crash. I always restart them with sudo service mysql restart.
Although I know I need to investigate why they ...
- 1,434
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 ...
- 13.6k
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 ...
- 423
26
votes
4
answers
86k
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 ...
- 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
...
- 253
5
votes
3
answers
6k
views
MySQL localhost connect works but 127.0.0.1 does not
Does anyone know what the error could be when I can connect to my MySQL server via localhost but not via 127.0.0.1? AFAIK, these should be routed identically and no additional TCP layer should be ...
- 720
4
votes
6
answers
2k
views
Is MySQL installed by default with OS X Leopard 10.5 or 10.6
If so where can I find the installation?
Lee Dale
4
votes
2
answers
8k
views
Rails: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
So I've got a Ruby on Rails application that I am trying to run (in development) on Snow Leopard. I've got it working on my Ubuntu computer, but now I need to get my Snow Leopard environment set up.
...
- 14.9k
1
vote
1
answer
2k
views
Can't install MySQL on Mountain Lion
I have clean 10.8 OS X (with Retina MacBook Pro).
I have totally the same situation like here
Can't re-install MySQL on OS X Leopard after uninstalling
and similar with that
https://...
- 51
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 ?
user256743
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 ...
- 1,131
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 ...
- 1,085
24
votes
5
answers
20k
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, ...
- 341
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 ...
- 1,449
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:
...
- 334
12
votes
6
answers
168k
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 ...
- 256
11
votes
7
answers
111k
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 ...
- 460
10
votes
2
answers
17k
views
What does the MySQL "max_allowed_packet" setting actually control?
We've been cleaning up database problems for the last four hours, thanks to a broken mysqldump that wasn't sufficiently erroring out. We were getting these errors:
mysqldump: Error 2020: Got packet ...
- 561
9
votes
3
answers
12k
views
Difference between mysql, mysql-server, mysql-client in Linux
I've installed mysql, mysql-server or mysql-client on Linux. What is the difference between them?
- 215
9
votes
3
answers
47k
views
How to restore mysql database using files on data folder?
I cannot run my mysql since yesterday, and I cannot access it, so I decided to reinstall it. I've backed up the data folder, which I presume contains all I need to restore the database after I ...
- 1,748
7
votes
1
answer
5k
views
I believe I've deleted MySQL root user, how do I recreate it?
I'm running ISPConfig on CentOS and I don't know how, but I don't seem to have a root mysql user.
I can stop mysqld with
/etc/init.d/mysqld stop
Start it again and skip grant tables
mysqld_safe --...
- 193
6
votes
2
answers
5k
views
Start MySQL from the command line without losing prompt
I'm on Windows 7. I'm trying to run a .bat file where I stop and start MySQL and run some other commands.
However, running "C:\Program Files (x86)\EasyPHP\binaries\mysql\bin\mysqld.exe" results in ...
- 171
4
votes
1
answer
556
views
MySQL quiet installation references wrong executable
I am trying to install MySQL 5.5.27 (latest) quietly from the Windows (XP) command line via batch file using the MSI method. Following the directions on the MySQL site, I simply do this:
msiexec /i /...
Michael Moody
4
votes
2
answers
8k
views
restoring a mysql db via powershell
Say I have the following command:
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql" -u user --password=pass dbname < backup.sql
It works fine in cmd but in PowerShell I get the following:
At ...
- 7,122
4
votes
2
answers
5k
views
launchctl: Dubious ownership on file (skipping) (Mac OS X)
I installed mysql recently and added its start command in my .bash file. But when I tried running the command, that's when I encountered this error:
launchctl: Dubious ownership on file
(skipping)...
- 2,577
3
votes
3
answers
543
views
How to store the data of mysql on OS X in an encrypted state?
I have mysql 5.1 installed by macports with it's data dir in the default location, which is outside my user directory that's protected by filevault.
I'd like to store the data in an encrypted state ...
- 9,853
3
votes
1
answer
32k
views
Why is “mysqld.pid” and “mysqld.sock” missing from my system even though the values are set in “my.cnf?”
I was working on an answer to this question—on one of my Ubuntu 12.04.5 development servers—and realized that the MySQL install was not creating mysqld.pid and mysqld.sock files despite their paths ...
- 55.6k
3
votes
1
answer
1k
views
Initialize MySQL database as non-root and run SQL server for testing
I want to do some MySQL-specific testing and need to run a fresh MySQL database as non-root user. I am using Debian Linux and expect one could start the mysql_install_db and other commands as normal ...
- 825
3
votes
1
answer
5k
views
How to use PuTTY to tunnel to database
I am trying to connect to a remote MySQL database on an Ubuntu 18.04 server using a putty tunnel on my Windows 10 home computer.
Using putty, I can connect to my Ubuntu server terminal via SSH. This ...
- 966
3
votes
3
answers
139
views
Why do I need ./ for commands to run on Mountain Lion? [duplicate]
Possible Duplicate:
What does “/” , “./”, “../” represent while giving path?
Why do I need ./ for commands to run on Mountain Lion?
For example, when using mysql I have to type in the terminal:
...
- 131
2
votes
0
answers
838
views
upgrading to MySQL 5.7 from 5.6
I downloaded MySQL Installer 5.7.10, thinking it'd update the version of MySQL I have from 5.6.27 to 5.7.10 and... it doesn't seem to be able to.
I could manually backup my databases, uninstall 5.6....
- 7,122
2
votes
1
answer
4k
views
load csv file into mysql using batch?
I am looking for help to load a .csv file into MySQL Server using batch and I have few basic questions.
Issues:
1) The CSV file data may have , (comma) in between (Ex: description), so how can I ...
2
votes
1
answer
216
views
How to make Joomla and MySql in separated VirtualBox machines communicating?
I have:
A Linux Mint 18.3 host machine (192.168.1.19)
A VirtualBox Windows Server 2012 guest machine with a Joomla installation on IIS8.5+PHP7 (192.168.1.8)
A VirtualBox Windows Server 2012 guest ...
2
votes
5
answers
3k
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 127.0.0....
- 51
2
votes
1
answer
5k
views
Import or restore MySQL databases from var directory
I recently backed up my entire laptop hard drive with SuperDuper and reinstalled Snow Leopard. Because I made an image clone, I was able to restore all my files without losing any data. Go hard drive ...
- 2,489
2
votes
1
answer
18k
views
How to change mysql port
I'm using wampserver. And suddenly mysql wouldn't work. I checked curports from nirsoft and it has red highlight on it. What does it mean?How do I solve this so that I could use mysql again. I'm ...
- 6,542
2
votes
1
answer
7k
views
Why can't I access MySQL server with port forward rule in router?
This is my setup (the relevant parts, anyway):
I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
- 317
1
vote
1
answer
1k
views
MySQL Crashed, Logs Have Many Errors, DB Possibly Corrupted
I run a LAMP server on Digital Ocean with a WordPress installation on it for a friend's website. I recently transferred it over from AWS. It crashed and I received the Error establishing database ...
1
vote
1
answer
927
views
Use MySQL to select the next one record after a matching value without a sequential RowID
How can I select all rows next to the row matching with the condition? But considering there is not a secuential RowID like ID Field
This is the table structure with 10 rows, but the number of rows ...
- 83
1
vote
2
answers
3k
views
What's my MySQL root password
I just installed mysql-server with the following command
$ sudo apt install mysql-server mysql-client mysql-common
Then when I call the command mysql_secure_installation MySQL asks to enter the root ...
- 11
1
vote
1
answer
2k
views
OpenSSH tunnel and connect to MySQL
Hi I'm trying to use PuTTY to open a SSH tunnel and connect to a remote MySQL server.
PuTTY:
Remote SSH Server IP and port
MySQL Port on the remote server
Tunnel: Local address and port on local ...
- 115
1
vote
1
answer
4k
views
ownCloud MySQL table “oc_filecache” corrupt, can I regenerate it?
My ownCloud upgrade failed due to MySQL data corruption.
Examining the error log, it appears that the corruption affects the owncloud.oc_filecache table.
I tried running check table owncloud....
- 1,100
1
vote
1
answer
5k
views
How To Investigate/Restore MySQL Permissions? MySQL ERROR 1045 (28000): Access denied for user
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Debian.
mysqld is listening on 3306 supposedly
Telnet to 3306 works
Also tried binding it specifically yo ...
- 214
1
vote
2
answers
4k
views
Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
i am working on windows 7 ..i am using xampp . i restarted my computer then after that when open the mysql yog..then it gives me an error
error no 2003
can't connect to mysql server on localhost (...
user1972143
1
vote
1
answer
485
views
Can't re-install MySQL on OS X Leopard after uninstalling
I'm running Leopard (10.5.8) on a Macbook (not Pro) and I had MySQL running ok, but the Preferences pane wasn't working. I thought a fresh install would be a good idea, so I went through the uninstall ...
- 11