New answers tagged

0

It happened to me as well and I fixed it by: uninstalling the package $ whereis apache2 manually remove anything related to it fresh package reinstall


0

Yes, it is possible. MariaDB is highly compatible with MySQL "MariaDB intends to maintain high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands" Yes, it can be accessed using phpMyAdmin "Here is a list of tools that are known to work properly with ...


0

I just managed to fix that by: Login with sudo: sudo mysql -u root Updating the plugin which were auth_socket: update mysql.user set plugin = 'mysql_native_password' where User='root'; FLUSH PRIVILEGES;


0

Ashish, Make sure that your NTFS partition is mounted with read-write option. You can mount your NTFS partition /dev/sda1 using following command. sudo mkdir /mnt/ntfs/ sudo mount -t ntfs-3g /dev/sda1 /mnt/ntfs/


4

Those commands go into ~/.mysql_history.


0

You can use XAMPP Linux.You can download any version of xampp linux from the below mentioned official xampp site. https://www.apachefriends.org/download.html Enter downloaded file location using terminal. First give certain permission for the downloaded binary file. (Assume that i downloaded 64 bit binary package.) sudo chmod a+x xampp-linux-x64-5.6.23-0-...


0

Have you tried this ? -- https://github.com/lanyrd/mysql-postgresql-converter ; Read through it, it's pretty self-explicit


1

After changing the data directory you need to change the Apparmor settings to solve the permission issue Open /etc/apparmor.d/usr.sbin.mysqld Comment out /var/lib/mysql/ r, /var/lib/mysql/** rwk, Then /mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6/ r, /mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6/** rwk, Also see to it ...


0

The package is available for Xenial and it can be seen here. Therefore, it should install. Make sure you run a sudo apt-get update before installing. Also, make sure that the universe repository for Xenial is part of your sources (as the above link shows, this package belongs to the universe repository). You can check this source is part of your available ...


0

Don't reinstall. If you don't have any valuable data in your databases, you can try this : sudo dpkg --remove --force-remove-reinstreq mariadb-server


-1

If you use courier IMAP it's also possible to authenticate using its authdaemon like this https://www.hostsom.com/postfix-mysql-courier-imap-ubuntu-16-04-part3/


2

Dynamic link libraries (DLLs) are a Windows-specific technology and don't work on Ubuntu. Because PHP can be run on different operating systems, its configuration files contain examples for how to configure it on different operating systems: ;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;; ; If you wish to have an extension loaded ...


0

After performing the above steps, please follow below steps. sudo apt-get update sudo apt-get install mysql-server sudo apt-get update sudo apt-get install mysql-server-5.6 sudo mysql_secure_installation mysql --version


0

Use the endpoint of s3 bucket. Ex URL: bucketname.s3-website-us-west-1.amazonaws.com You can obtain this URL in s3 properties. use the URL instead of bucket name to download.


2

There is not really a need for a bash script. First, work out what backup command would work for you. In principle, you could do something as easy as: mysqldump > /path/to/mysqldump.sql 2>/path/to/mysqldump.err This will write the contents of all the data bases to a file called mysqldump.sql. The form of this is such that, if you need to restore the ...


2

I would suggest you change your vhost to name based: Replace the IP address with *:443 and add ssl certificates set the server name to your alias minus the www. add a second vhost for http which only redirects to https This should allow you to use vtiger from the local network and from the outside world and has added security through https. Now let's ...


0

1-Connect to your RDS instance: mysql -h <host_name> -P 3306 -u <db_master_user> -p 2-For SQL format, use the following command: mysql> source backupfile.dump;


0

Try with sudo dpkg -l | grep mysql It will list the packages belonging to the mysql. Then try the following command sudo apt-get --purge autoremove mysql* sudo apt-get autoclean After that sudo rm -r /var/lib/mysql sudo rm -r /etc/mysql After the above steps try installing mysql again.


0

AuthMySQL_Authoritative Off also worked for me (as a line in the Virtualhost config). I believe it allows mod_auth_mysql to pass the credentials on to mod_auth for authentication.


0

Try installing it with: sudo apt-get install php7.0-mysql If package could not be found: sudo apt-get install python-software-properties sudo add-apt-repository ppa:ondrej/php-7.0 sudo apt-get update sudo apt-get install php7.0-mysql


0

Why don't you use, the regular aws cli? I never had any problem with it, and maintained by the provider. I recommend it because I had some issues with s3cmd. You can install it easily with pip install awscli, then just run aws configure (where you have to enter some config details and credentials). If you don't have pip installed, you can just install it ...


0

I solved this problem using Synaptic Package Manager. I figured out that, in my case, I'm using different versions of MySQL common, server and client sides. In particular, for common I was using a mariabd repository to get the file. I've change this using Package > Force version in Synaptic and choosing the same version (5.7.12) for all packages. Hope ...


1

Try the following code in your terminal sudo service mysqld restart I think thats what your looking for


0

On a default Ubuntu installation, the Apache configuration file, /etc/apache2/apache2.conf contains the following line to ensure that log files are written by default. ErrorLog ${APACHE_LOG_DIR}/error.log The APACHE_LOG_DIR environment variable is set when the Apache service startup script run the shell commands in /etc/apache2/envvars, which include this ...


0

That is normal behaviour for sudoedit A symbolic link is just a pointer to a regular file. You want to edit the file pointed to by the symlink, not the symlink itself. You can do this using by calling a text editor directly, for example sudo nano /etc/mysql/my.cnf will follow the symlink to the file it points to and allow you to edit that file. But it ...


0

My bash script for backup MYSQL to S3. SERVERNAME="YOUR_SERVER_NAME" TIME=`date +"%Y-%m-%d-%H-%M"` FILENAME="backup-DB-$SERVERNAME-$TIME.sql.gz" DESDIR="/var/backfile" mysqldump -u root -pYOURPASSWORD YOURDBNAME | gzip -9 > $DESDIR/$FILENAME /usr/bin/aws s3 cp $DESDIR/$FILENAME s3://YOURS3BucketName /bin/rm $DESDIR/$FILENAME ...


0

Mariadb package doesn't offer a configuration wizard during installation on Ubuntu 16.04. Use the below command to have a mysql shell sudo mysql -uroot


0

Try sudo mysql -u root. You should be able to login this way.


0

does the script work, if you execute it yourself? if so - try replacing /bin/sh in the crontab with /bin/bash +x and replace /dev/null with /tmp/debug-mysqlbackup.log - this will output all steps to the file /tmp/debug-mysqlbackup.log (still can't create comments ... ;-D)


0

Some Basics cron A user can utilize the crontab utility to edit his/her crontab. The cron daemon will consume all crontabs and run the commands at the defined interval. A crontab entry basically looks like this: * * * * * /path/to/some/command mysql backup Backup of a mysql database can be achieved through various methods; depending on database engine ...


0

Assuming you have installed aws-cli (and the machine has a IAM role with permission to upload to S3) and mysqldump in the machine you want to run the cron job, this is the way I do it: mysqldump --defaults-file="path_to_config_file_with_password" -u db_user -h db_hostname db_name_you_need_backup | gzip -9 > db_name.sql.gz; now=$(date +"%m_%d_%Y") aws s3 ...


0

That script needs you to define root password for you database and you S3 storage's bucket name. So edit it first then try executing it. That command skips information_schema, performance_schema, mysql & test databases which usually not needed for backup porposes. I would suggest for you to replicate current setup of your database to a development ...


0

It will be resolved by the below command sudo dpkg -l | grep -i mysql


1

We found that a 3rd party web app was managing it's own session files and failing garbage collection. Once we deleted some very old folders of them, the issues disappeared.


0

THANK YOU for bringing that mysqladmin ping command to my attention! It's going to be a big help when dealing with Docker. Here's what I ended up doing: # Returns true once mysql can connect. mysql_ready() { mysqladmin ping --host=database --user=root --password=MYSQL_ROOT_PASSWORD > /dev/null 2>&1 } while !(mysql_ready) ...


0

You can prevent a package from being updated by running the command sudo apt-mark hold package In your case, it should run sudo apt-mark hold mysql5.6 If you wish to update it later, you can run sudo apt-mark unhold package


0

I managed to solve the problem using a previously answered question, How to install mysql on Ubuntu 16.04, but I needed to modify the solution to work for me. When I deleted/moved /var/lib/mysql directory, mysqld --initialize couldn't create the database directory I want in replacement for /var/lib/mysql , and it gave me Errcode: 13 - Permission denied ...


0

GUI tools that have not been mentioned here, that I know work under Linux without WINE: DBeaver http://dbeaver.jkiss.org/ (Java, GPL) Squirrel http://www.squirrelsql.org/ (Java, LGPL or GPL) ocelotgui https://github.com/ocelot-inc/ocelotgui (C++, GPL) Disclosure: I work for Ocelot.


2

I have found a solution with help from "steeldriver" Problem: My problem was that i run forever start myscript.js with user root, forever save all logs in folder of the user that run the script, that is why i have no space in /dev/md1 Solution: move all files that was in /root/.forever to my new user, /home/user/.forever and run forever start myscript.js ...


0

Fixed running to instance of mysql or apache by default is not possible because the first one will use the default ports and the second one can't run properly because the ports are in use. – Mic0 find out How do I start/stop mysql server? stop it via terminal and restart via ampps worked fine for me. sudo /etc/init.d/mysql stop [sudo] password di ...


0

The problem is that the configuration file contained a directive that prevented mysql from starting. As long as it was in error (without the group), it was not loaded so that the error didn't come to life and the server could start w/o error. I troubleshooted this by starting and then stopping the mysql service with the group properly written on top of the ...


0

In Ubuntu 16.04 the way to fix it in my case was (please backup DBs first): sudo apt remove --purge mysql-server mysql-client mysql-common sudo apt autoremove sudo rm -rf /var/lib/mysql* sudo apt install mysql-server (Somehow, my previous calls to apt purge mysql-server didn't seem to succeed. I thought that apt purge foo was equivalent to apt remove --...


0

dpkg --force-depends -P `dpkg -l |awk '/mysql/{print $2}'` rm -r /etc/mysql/ apt-get install mysql-server mysql-client


1

Connection string depends of software you use, but yes, if you are on same machine with webserver and database, you refer to it as localhost or 127.0.0.1 or by hostname too, if you wish.


0

Using the MySQL CLI client. $ mysql -u <user> -p mysql> use <your-database> mysql> DELETE FROM `wp_posts` WHERE `post_type` = "attachment" Notice that I'm using -u and username, but in -p I'm not setting anything. MySQL will ask you for your password. And if you're trying to use it inline, you can use $ mysql -u <user> -p <...


1

Try this: mysql --host *HOST_IP* --user *USER* --password=*PASSWORD* -D *DATABASE_NAME* -e "DELETE FROM `wp_posts` WHERE `post_type` = "attachment" ;


0

I finally remove everything mysql components ( mysql-server, mysql-server-5.7, mysql-server-core-5.7 ) and data ( /var/lib/mysql , /etc/mysql ) and do a fresh install of it . Everythings works fine now. I thing the mysql internal dbs were somehow corrupted or with data missing during the migration from 5.6 to 5.7 ( from the change log , the column ...


0

From Learning MySQL: AppArmor and MySQL If you want to relocate the data directory in MySQL (in this example, to the /data/directory), and AppArmor is not letting you, add the following two lines to the bottom of /etc/apparmor.d/local/usr.sbin.mysqld: /data/ r, /data/** rwk, ...and then reload the AppArmor profiles: sudo service apparmor reload


1

After I founded the error message in /var/log/mysql/error.log 2016-07-06 07:15:03 58630 [ERROR] /usr/sbin/mysqld: unknown variable 'audit-log=ON' Then I opened the config file /etc/mysql/my.cnf and founded a row with the statement audit-log=ON I deleted that row and tested to start the server again with sudo /etc/init.d/mysql start the first time it did't ...


0

Instead of using xampp i would recommend to install the ApachePHPMySql thingy in ubuntu. https://help.ubuntu.com/community/ApacheMySQLPHP EDIT: The ubuntu phpmyadmin documentation is found here: https://help.ubuntu.com/lts/serverguide/phpmyadmin.html



Top 50 recent answers are included