All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
2answers
128 views

MySQL 8.0.17 on Windows - I forgot my root password, dont need to keep any previous DBs

I have previously used MySQL for a class about a year ago and not since. I've forgotten the password and I need to use it again. I don't need to be able to access any previous databases, so I tried ...
0
votes
0answers
39 views

MySQL 5.27 on Fedora 30 not starting

I wanted to install MySQL on my dev Fedora machine for my work. I followed the following tutorial: Install MySQL 8.0/5.7 on Fedora 30/29. However, when I tried to start the service via sudo systemctl ...
0
votes
0answers
58 views

MySQL server start fails

I was trying to reset a forgotten password by accessing server as root, with --skip-grant-tables, as some tutorials suggested. However, I think I messed some internal configurations. I tried ...
0
votes
0answers
15 views

Missing directory after MySQL 8.0 for Ubuntu installation

After installing MySQL Community Server 8.0.16-2 on Ubuntu 19.04 I have the directory /var/run/mysqld missing and the server refusing to start. What's wrong?
0
votes
1answer
140 views

Moving MySQL databases/folder to another disk

I want to separate MySQL database from the OS (Ubuntu) disk by moving the entire database to an exclusive HDD (M.2), and update the database folder in my.cnf. My question is: when the MySQL folder is ...
0
votes
1answer
1k views

MariaDB startup failure on Ubuntu 18.04

I have installed MariaDb hundreds of times on previous Ubuntu versions, but on Ubuntu 18.04 I'm struggling. After the installation finishes, once I restart the PC, MariaDB starts for around 2 minutes ...
3
votes
2answers
665 views

How to change MySQL InnoDB cluster from single primary mode to multi primary mode?

My goal is to setup, in a lab environment, a MySQL InnoDB cluster in multi-primary mode. I have read much, but I cannot get this setup to work. Ubuntu 16.04.3 server LTS x 3 SQL0 - SQL2 Ubuntu 16....
1
vote
0answers
84 views

Specific install of MySQL 5.6

I'm download this version mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz. I would like to make a specific install for example : basedir = /sgbd/mysql/5.6/mysql datadir = /data/mysql/MYSDTESTP02 socket = /...
1
vote
0answers
483 views

Can I reinstall Wamp on Windows 10 without overwriting my databases?

I have another open question which at the moment seems to be a bit tricky to answer: phpMyAdmin - Cannot login even when changed password I am hoping someone can still answer it. I think one of the ...
1
vote
0answers
514 views

MySQL 5.7 not configured yet

I have a personal webserver which were running under Ubuntu 14 LTS and I migrated it under 16.04 LTS a while ago. Since I did it I have an error with MySQL server every time I'm updating packages on ...
3
votes
1answer
5k views

Can't open the mysql.plugin table error when installing MySQL on Mac OS Sierra

I am attempting to install MySQL on macOS Sierra 10.12.5. I had a previous (non-functioning) install of MySQL so I followed the steps here to install a clean copy with Homebrew. I had to create a var/...
-1
votes
1answer
20 views

Mysql crashes on fresh installation

I try to run mysqld and here's the dump I get: https://pastebin.com/TCk2YWQN I tried re-installing mysql, but the same thing happens. Just running mysql returns ERROR 2002 (HY000): Can't connect to ...
3
votes
2answers
12k views

MySQL fails to start on arch Linux. Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

MySQL fails to start on arch Linux. mysqld[3440]: [Note] /usr/bin/mysqld (mysqld 10.1.22-MariaDB) starting as process 3440 ... mysqld[3440]: [Note] InnoDB: Using mutexes to ref count buffer pool ...
3
votes
1answer
879 views

mysqld not starting up

I installed mysql on ubuntu. mysqld does not startup with the following errors - 2017-04-16T00:22:35.320639Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-04-16T00:...
0
votes
2answers
4k views

During installation can't change directory

I try to install mysql db server on windows 10. Version mysql-installer-community-5.7.16.0.msi During the installation Install MSI does not offer to change the installation directory. Do I ...
1
vote
1answer
469 views

MySQL unique static ID

I need to get an unique static ID that is not changeable by the users, and if the user copies the database to another server this static ID is different. Background My company wants to sell our app ...
0
votes
2answers
852 views

Unable to install MySQL 5.7.12 in RedHat in a separate directory

I am trying to install the MySQL version 5.7.12 into RedHat in a non default data path. The installation syntax used /app/mysql/5.7/bin/mysqld --initialize --user=mysql --basedir=/app/mysql/5.7 --...
2
votes
2answers
5k views

MySQL5.7 (Windows) how to install from zip file without the Data Directory?

This has probably been asked before, but I am struggling to find the answer. Historically I have always installed MySQL (on Windows) from a template based on the mysql-xxx-win64.zip file. I would ...
1
vote
3answers
451 views

Any script to auto test tune and benchmark mysql config?

I'm looking or willing to do a script to benchmark mysql config variations for a specific system. A script that would change certain mysql config values and do a sysbench, save results, change ...
2
votes
2answers
2k views

Run multiple MySQL instances in Windows

Which is a better way to install multiple instances of MySQL / MariaDB / etc on a single Windows box? Manually setting different ports? Docker? Virtual Box? Something else? (Sandbox, mysql_multi, ...
0
votes
0answers
341 views

Install two instances of mysql 5.6 and 5.7

How to install two mysql servers on one Debian server? apt-get install libaio1 wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-server_5.7.11-1debian8_amd64.deb-bundle.tar tar -xvf mysql-...
0
votes
1answer
31 views

why MySLQ datadir must be owned by mysql user?

I read this from MySQL document: Otherwise, most of the MySQL installation can be owned by root if you like. The exception is that the data directory must be owned by mysql. Can somebody tell me ...
2
votes
3answers
9k views

MySQL 5.7 doesn't start after installation on CentOS 6.7

I have just installed MySQL 5.7 on a fresh CentOS 6.7(vm). When I start the MySQL service with this command: sudo service mysqld start It doesn't start and raise this error: Initializing MySQL ...
2
votes
2answers
966 views

MySQL - installed version 5.5 but mysql --version says 5.0.95

I'm running CentOS 5.2 and upgraded MySQL to 5.5. When I run mysql I get this: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 Server version: 5.5.45 MySQL ...
0
votes
1answer
401 views

install Galera but mariadb existing on system

I try to install galera on ubuntu 14.04 system. It has already got mariadb and it's working. How can I install it? my command : sudo apt-get install -y rsync galera-3 mariadb-galera-server it ...
0
votes
0answers
122 views

Installing MySQL 5.6 Community Debug Info

I have setup my yum repository as described here https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/, and am wondering where I can install the debuginfo packages. Looking here http://repo.mysql....
10
votes
2answers
2k views

Issues with MySQL installation

First of all, excuse the length, this post is very long, and needs some background, second; it has been hard for me discerning the signal from the noise, please bear if some of this is not relevant: ...
0
votes
1answer
664 views

MySQL server installation file download for windows

I need to install latest MySQL community server 5.6.25 in windows box. MySQL site is giving complete MySQL installer, but not particular MySQL server installation file. Where can I get this ...
16
votes
2answers
48k views

Backup/Restore Users/Passwords/Privileges

I am moving from one server to another and I want to backup all databases + users/privileges/passwords from my MySQL Server. I found to backup a database using mysqldump, but I cannot figure out, how ...
1
vote
1answer
1k views

MySQL Install on Windows 8.1 hangs at server restart

I have a 64-bit Windows 8.1 machine and would like to install a local database to host some helper application databases. I have attempted this several times with this version of MySQL (5.6.25 GA) but ...
3
votes
1answer
252 views

MySQL running fine while data files (disk) are not present. Data folder nowhere to be found

I'm running MySQL server 5.6 on Windows 2012 R2, and since the installation didn't go as planned, I had to re-install it to change the data directory path. The installer for some reasons never gave ...
0
votes
1answer
4k views

Change MAMP to use a lower Mysql 5.1 version

I need to have the same development environment for my PHP program. My clients test server is running on Mysql 5.1 while my local is using MAMP running Mysql 5.5. How do downgrade my mysql database ...
-1
votes
1answer
60 views

What makes yum difficult with RAID [closed]

I as working with someone on a redhat server using RAID 10 with MySQL, and they mentioned it is hard to use yum when having a raid setup. Is this true? If so, what actually makes it 'difficult'?
0
votes
1answer
3k views

Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5

I have installed MySQL-5.6.x community edition on RHEL5. It was running fine. Since, it is my testing server. To find the differences in execution timing, I have to install the MySQL-5.1 community ...
0
votes
1answer
149 views

Can't find source code for building mysql

I'm trying to follow the instructions for building MySQL from source. They guide me to a link where I can download the latest GA. I end up at the downloads page, where I can download mysql-5.6.19-...
0
votes
1answer
101 views

Mysql tar ball installation

I need to install two different versions of Mysql in one server OS RHEL6 and it will be separated by user called mysqlprod and mysqlpreprod. I need to separate their binaries, softwares,data ...
0
votes
0answers
51 views

Install/bootstrap mysql without name-based users

Like many people, I run mysql with skip-name-resolve (docs), and only ever use IP addresses to connect to avoid DNS issues and overhead. When installing, mysql_install_db accepts a --skip-name-resolve ...
1
vote
0answers
123 views

crossplatform mysql_install_db script in mysql 5.5.34 on Windows

I downloaded mysql-5.5.34-win32.zip and found out there is mysql_install_db.pl script. However mysql 5.5 documentation says: mysql_install_db is a shell script and is available only on Unix ...
1
vote
2answers
695 views

Install MySQL on Ubuntu 12.0.4

This is my first time using Linux. I am trying to install MySQL 5.6.15 on an Ubuntu box. I download MySQL from their website and put it on a USB stick then plugged the stick into the box. How can I ...
0
votes
0answers
295 views

Cannot find /etc/init.d file in opensolaris

While installing MySQL , I noticed a point, I mean to start the MySQL server manually , use the command cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql The error shown is : cp: ...
2
votes
2answers
9k views

Access denied for user 'root'@'localhost' (using password yes)

I was trying to install MySQL 5.6.15 to my computer and got this error: unable to update security settings. access denied for user 'root'@'localhost' (using password yes) I guess current root ...
2
votes
2answers
1k views

MySQL login after secure installation

I have installed mysql5.5 via secure installation procedure by using: sudo mysql_secure_installation Now when I am trying to login in MySQL from the terminal by using: sudo -u root -p The ...
1
vote
0answers
226 views

problem installing mytop , need a up to date tools for monitoring mysql

so i'm trying to installl mytop to monitor the database i'm following this instruction : http://www.sohailriaz.com/how-to-install-mytop-a-top-clone-for-mysql/ when i try to install it with yum i get ...
0
votes
1answer
1k views

Install MariaDB and MySQL in CentOS 6 32bit in same server

I'm trying to install MariaDB with MySQL in the same server but got this errors: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package MariaDB-client.i686 ...
0
votes
1answer
5k views

Reinstall MySql but keep database tables and data

Please help! There are server issues and MySql is no longer running on our server (Ubuntu). The service is not recognized and needs to be reinstalled. Unfortunately, the database has not been ...
1
vote
2answers
9k views

MySQL Installation error: Unable to update security settings

I tried to configure MySQL server 5.5 on Windows and this is what I got: mysql-server-5.5-winx64:56 - Attempting to update security settings. mysql-server-5.5-winx64:100 - Unable to update security ...
1
vote
2answers
2k views

what's the optimal partition setup for a linux db server?

My host wants to know how I want to partition my server before installing CentOS. I need to be able to do use xtrabackup to create quick backups from 20-50GB databases. I know I need to use a LVM, but ...
1
vote
1answer
4k views

Can we back up mysql databases by copying files?

I tried to reinstall mysql on my machine, but it keeps failing. Everytime it fails, it does this locking and that locking and future effort would fail again. Finally I decided to do truly clean ...
2
votes
1answer
2k views

How do you set the MySQL password on Mac OS X?

I've downloaded mysql 5.25 on mac os x Lion (10.7.4). I just tried setting my password in the usual way, however I'm getting an access denied error which is odd: [user@Macintosh:~] #mysqladmin -uroot ...
1
vote
2answers
513 views

why can I only install MySQL 5.1 on cent OS 6.2?

I had Ubuntu 10.10 on my server and MySQL 5.1 version. But since i wanted to update the system, I installed a fresh version of Cent OS 6 only so I could install the latest version of MySQL. But after ...