Tag Info

New answers tagged

0

I would combine parts 1 and 2. MySql allows you to take encrypted backups as detailed here: mysqlbackup --backup-image=/backups/image.enc --encrypt --key-file=/meb/key --backup-dir=/var/tmp/backup backup-to-image The next bit would be to push the image up to a cloud service. This comes down to personal preference. If you like Dropbox, it has a ...


0

Step 1 : Download XAMPP for Linux 5.5.24 & 5.6.8 click here Download Step 2 : open terminal ( Ctrl+Alt+t ) cd Downloads sudo su chmod 755 xampp-linux-x64-1.8.3-1-installer.run ./xampp-linux-x64-1.8.3-1-installer.run Step 3 : follow the instructions Step 4.1 : Start Apache,MySQL /opt/lampp/lampp start Step 4.2 : stop Apache,MySQL ...


0

To install the latest Apache version, simly run these commands on Terminal: sudo apt-get update sudo apt-get install apache2 To use the PHP and MySQL versions you mentioned, you simply need to install them following this general rule: apt-get install <package name>=<version> But before doing that, I seriously do not understand why you need ...


1

You can't access mysql with user root without using a username, this is normal behavior of mysql. All you have is to provide the password using -p option mysql -u vindhya -p userPassword


1

At installalation mysql-server asks for a password, this is for the mysal root user,who is not identical to your systems root user. Mysql has its own users. Look in /etc/mysql/conf.d/debian.cnf for user debian-sys-maint user and pawword and connect with mysql -u debian-sys-maint -p It will ask for the password that is also in that file.


0

The password you entered is wrong , try typing your correct password or Follow the link so that your problem gets solved https://help.ubuntu.com/community/MysqlPasswordReset


0

You should have been able to set up a password while installing MySQL. Assuming you did, you should use the following syntax to log on to your server: mysql -u vindhya -pyourpasswordnexttotheP -h127.0.0.1 If you get the same or similar error, try: mysql -u vindhya -pyourpasswordnexttotheP -h127.0.0.1 --protocol=tcp


0

In searching around I came across a better script and decided to try it, and it works: #!/bin/bash PATH=/usr/sbin:/usr/bin:/sbin:/bin if [[ ! "$(/usr/sbin/service mysql status)" =~ "start/running" ]] then echo "MySQL restarted" | mail -s "Email Subject" email@domain.com sudo service mysql start fi More info can be found here ...


2

Yes, in theory this is possible, as long as you make sure that neither service is running at the time of the copy/paste, and the new server is the same version as the old one. However, as you are well aware, it is not the recommended way.


0

Try doing a purge, then re-install. sudo apt-get remove --purge mysql-server sudo apt-get install mysql-server-5.6


0

Error writing /etc/phpmyadmin/config.inc.php: Permission denied You are trying to upload /save in /etc/phpmyadmin, while this directory have some permissions that disable user from writing on it, so you have to choose one of many scenarios to solve that: Change the dir to some dir in your home change permission of that dir using chmod. Read this for ...


0

dpkg --get-selections | grep "mysql"(It list all installed mysql in your system) If still mysql installed In Your System remove it first by using following commands. sudo apt-get --purge remove mysql sudo apt-get autoremove mysql sudo apt-get autoclean mysql check for /etc/mysql/my.cnf and /var/lib/mysql files. If these files still exist then ...


3

For what the output means see this answer. Note that mysql is probably not the cause of the problem. Linux by default overcommits memory and then when processes actually start to use it, it has to kill some other process to get some memory. Often it chooses whatever is big and not much used. You can protect a process from being killed by doing echo -1000 ...


1

These look like process id, user id, and again process id, respectively. Can't see what is in the last column, probably some indication of memory usage.


0

When you connect to "localhost" the socket connector is used, but when you connect to "127.0.0.1" the TCP/IP connector is used. You could try using "127.0.0.1" if the socket connector is not enabled/working. Also try to enable the socket again by: sudo ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock sudo service mysqld restart


1

Remove the cached deb file: sudo rm /var/cache/apt/archives/mysql-server-5.5_5.5.43-0ubuntu0.14.04.1_amd64.deb and try it again: sudo apt-get install -f sudo apt-get install mysql-client mysql-server Alternatively, install version 5.6: sudo apt-get remove mysql-server mysql-client sudo apt-get install mysql-server-5.6 mysql-client-5.6


0

Uninstalling and reinstalling the gem often solves the problem .That solution worked for me . gem uninstall mysql2 and then bundle install Hope that works .


0

run the command: sudo dpkg-reconfigure phpmyadmin u need to reconfigure it because lampp and xampp run phpmyadmin in different ports. So, its probably a ports conflicts. You can also open server.xml in your lampp and change the port no. which would be different from that of xampp. Then both mySQL(of xampp and lampp as well) will run.


0

Just run the command: sudo dpkg-reconfigure phpmyadmin


1

libmysql-ruby appears to be a transitional package that has been phased out: the new package name seems to be ruby-mysql. If you are running Ubuntu 14.04 or later you will need to use sudo apt-get install ruby-mysql


1

During the installation of mysql-server you should have added a root password for the mysql account. This is what you should be using to configure the initial development databases. For exmaple, If I had a wordpress site that I wanted to develop on. Then I could do the following. Log into mysql: mysql -u root -p Create a new Wordpress DB create ...


-1

it should work chmod 1777 /tmp


0

One way you can acomplish that is with triger in my sql which will update additional field postfix_pass in owncloud user db every time new user is created or user pass changed. This is not best solution because of sha encryption of postfix users pass field. In postfix you configure auth.cfm to authenticate against owncloud user database but with pass ...


0

Building off of another answer, open a terminal (press Ctrl+Alt+T) and run the following: sudo -i service mysql stop killall -KILL mysql mysqld_safe mysqld apt-get --yes purge mysql-server mysql-client apt-get --yes autoremove --purge apt-get autoclean deluser mysql delgroup mysql rm -rf /etc/apparmor.d/abstractions/mysql ...


1

Unfortunately, there isn't enough information here to fully diagnose the connection issues. Your MySQL error log says that MySQL crashed but nothing about why. You can continue investigating if you'd like, but there's a solution you can apply in the meantime. Every five minutes, automatically restart MySQL if it's not accepting connections Note: this will ...


1

@Erik Stagg, I know it is late but indeed to use unoconv with other user you can leave an open a port with sudo in another process: $ sudo unoconv --listener Meanwhile this process is running, you can use unoconv with a normal user: $ unoconv -f docx file.doc


0

You've got a couple options. Here's my take, and you'll need a total of 4 servers: Start by moving your database off of the server now, and onto a server dedicated to the DB ('DB Server', #1 in this suggestion). Migrate it to its own MySQL instance on a separate server, and configure that server's firewall (and MySQL) to listen for connections ONLY from ...


0

Try NGINX as a load-balancer for two web servers: http://nginx.org/en/docs/http/load_balancing.html Use rsync over ssh to keep your doc roots in sync. Clustering MySQL will be trickier.


1

This can be rectified by the following steps sudo apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5 mysql-client-5.6 mysql-server-5.6 sudo apt-get autoremove sudo apt-get autoclean Clean the residue of the previous and the conflict installation sudo rm -rf /etc/mysql Install the new version sudo apt-get install ...


0

You could be running two different instances of Apache. One serving files from var/www/html and the XAMPP/LAMPP instance serving from opt/lampp/htdocs/ (That's the default LAMPP directory) If you have that directory you could copy your project to it. Then start apache inside of LAMPP and see if it works as expected. Note: For LLAMP your site might be ...


0

you do not have to run the apache2 service manually. LAMP is all you need as we all know LAMP = Linux, Apache, Mysql and Php


1

I use this method sudo ufw status sudo ufw alow XXXX/tcp # use a port other than the default/predictable 3306 # work outside, and close the door when you are done sudo ufw deny XXXX/tcp No need to change other conf files, and no extra port opened by default


1

It's a bug reported for all Ubuntu like distributions (probably happens to other distros too). Mysql is using editline lib instead of readline and that's breaking a lot of features we are used to, like ctrl + ← or ctrl + → to move between words, ctrl + r to reverse search, or even writing unicode characters is not possible. Even when he bug is flagged as ...


0

Try following command in a terminal-- sudo apt-get purge mysql-client-core-5.6 sudo apt-get install mysql-client-core-5.6 sudo apt-get install mysql-server


0

Edit: After reading what happened before the fast-forward. I think I would reinstall the whole OS. Too much different permissions in the whole /var structure. (And why would anybody advice a "chmod -R 777 /var"?)


0

mysqld_safe is just a script to start up the mysqld daemon. It exits as soon as the daemon is up and running, that is why you don't see mysqld_safe running with ps. You would see it, though, if you were very fast.


1

Check the file: /etc/mysql/mariadb.conf.d/mysqld.cnf verify if this line exists: plugin-load-add = auth_socket.so then go to MariaDB: sudo mysql -u root and make these modifications: MariaDB [(none)]>use mysql; MariaDB [(none)]>update user set plugin=' ' where User='root'; MariaDB [(none)]>flush privileges; MariaDB [(none)]>exit I ...


1

Stop the MySQL server before you start the backup sudo service mysql stop And you have a permission problem rsync: opendir "/var/lib/mysql" failed: Permission denied (13) therefore use the crontab of your root: sudo crontab -e I would prefer a backup with mysqldump. Thus, the service must be neither stopped nor restarted. mysqldump -u root -p ...


1

The exception occurs when there is no running or listening mysql service: Start the MySQL server Check the port number, you use the standard port 3306 in your code private static final String dbClassName = "jdbc:mysql://127.0.0.1:<your_port_number>/demodb"; Use the IP address of your Virtual Machine private static final String dbClassName = ...


1

As you probably have noticed, this is due to a JRE error. Make sure you have the following entries in your gem file: gem 'execjs' gem 'therubyracer', :platforms => :ruby I have seen posts in SE where users were able to solve this issue by installing nodejs. To do this, in your terminal run: sudo apt-get install nodejs


1

Ok, this is apparently due to the fact that recent MySQL versions in Ubuntu aren't compiled against readline anymore, but editline instead.


0

Mysql was not activated. The following commands helped me fix it. Stop xampp using the command /opt/lampp/lampp stop Restart it with /opt/lampp/lampp start


1

You have for some reason named the file "is_rsa" instead of "id_rsa". Also you should have copied the id_rsa.pub file, but you may be able to recover it from another host you have set up for password-free login. Last time I did this I archived the .ssh folder instead.



Top 50 recent answers are included