Tag Info

New answers tagged

0

For me, the reason this happened was that the root partition was full. Check to see how much free space you have on your root partition: df -h If you are out of space, see what's taking up that space: sudo apt-get install ncdu ; sudo ncdu /


0

This is a MySQL error. As this is a fresh install, just hit enter at the Enter current password for root prompt. The MySQL root user is not the system root user, and the system root user cannot magically get into the MySQL root account. They are different things entirely.


2

I believe you are trying to access the mysql port instead of accessing phpmyadmin. Phpmyadmin runs on port 80, so there is no reason to specify a port in the web address bar. Try going here: 127.0.0.1/phpmyadmin That should load up the web interface you are looking for.


0

There is a dependency from apparmor security settings You have to change configs to get tmpdir into RAM File: /etc/mysql/my.cnf tmpdir = /run/shm/mysql File: /etc/apparmor.d/usr.sbin.mysqld add a line alongside with other filesystem rules /run/shm/mysql/* rw, And shell steps to GTD service apparmor restart mkdir /run/shm/mysql chown mysql:mysql ...


0

Check your buffer_sizes, i assume you are using innodb, set the innodb_buffer_pool_size to a value which is lower than that of current one. The number of connections can also makes use of large memory, so set your max_connections value as low as possible make sure you have closed all the open connections in your application once they done their job. If ...


0

Two actions get resolved the issue. Removed value of: relayhost = [smtp.buyorsell.it]:587 as relayhost = and uncomment spamassassin unix - n n - - pipe in master.cf


1

Find apache.conf file of phpMyAdmin, regularly, it’s under /etc/phpmyadmin/ on Linux environment. Please edit this file with root authority: # phpMyAdmin default Apache configuration Alias /phpmyadmin /usr/share/phpmyadmin Change this –“Alias /phpadmin /usr/share/phpmyadmin” like this one ” Alias /secretcode /usr/share/phpmyadmin, secretcode stands for ...


0

Try adding the following line to your MySQL configuration file skip-name-resolve For Windows: my.ini(Mysql installation location ) For Linux: my.cnf(/etc/my.cnf) The ‘[mysqld]‘ section of the my.cnf file now looks like this after the changes: [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve Now restart the mysql service ...


1

I think you have problem with mysql connection now (where you keep user db, as far as I see). You should check permissions in mysql for dovecot to connect (user vmail) to the proper database. grant all privileges on your_database.* to 'vmail'@'localhost'; (assuming here that the database is local to dovecot, also all privileges may be a bit too broad for ...


0

If you move your datadir, you not only need to give the new datadir permissions, but you need to insure all parent directories have permission. I moved my datadir to a hard drive, mounted in Ubuntu as: /media/*user*/Data/ and my datadir was Databases. I had to set permissions to 771 to each of the media, user and Data directories: sudo chmod 771 *DIR* ...


0

As @muru suggested, I sent this question to MySQL and they replied that I should install "DEB Development Headers" package from dev.mysql.com, which is not included in repository. For Ubuntu 14.04 and MySQL 5.6.21 it would be: wget http://dev.mysql.com/get/Downloads/MySQL-5.6/libmysqlclient-dev_5.6.21-1ubuntu14.04_i386.deb sudo dpkg -i ...


0

Remove the file /var/lib/mysql/.run-mysql_upgrade and it should start ;) "With great power comes great responsibility"


1

You are trying to deploy to node 0 while using the LXC provider. Machine 0 is your host laptop, so deploying to 0 is explicitly disallowed so that you don't accidentally deploy workloads on your personal laptop/desktop. Deploying to any other machine except 0 with LXC will work. See also: https://lists.ubuntu.com/archives/juju/2014-October/004311.html


1

There are several packages providing a file called schema.sql. You can search in Ubuntu packages content using http://packages.ubuntu.com and its "Search the contents of packages" form. The query returns: /etc/freeradius/sql/mysql/schema.sql freeradius-mysql /etc/freeradius/sql/postgresql/schema.sql freeradius-postgresql ...


0

I turned out to be as simple as: sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean sudo apt-get install mariadb-server This won't break your phpmyadmin, or any webapp, as long as you say no, when asked if you want to delete your database and you use the same credentials you used for you ...


0

In the line smtpd_sasl_path = private/auth Basic SPAM prevention remove that "Basic SPAM prevention", leaving only smtpd_sasl_path = private/auth Then restart postfix.


0

You can edit the /etc/apt/sources.list file manually. From there, you can change all the servers back to http://mirror.learn.ac.lk/ubuntu . On my desktop, this is listed as the Sri-Lanka mirror. You can use gedit, nano, leafpad, vi, or your favorite text editor to open the file with sudo permissions. Example: sudo gedit /etc/apt/sources.list The file ...


0

Try this - sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean Then reinstall: sudo apt-get update sudo apt-get install mysql-server mysql-client It might be the autoclean and update that make a difference.


-1

Run sudo /etc/init.d/mysql stop


0

The mysql Upstart configuration has the respawn option: $ grep respawn /etc/init/mysql.conf respawn respawn limit 2 5 elif echo $statusnow | grep -q 'respawn/' ; then The respawn option tells Upstart to restart the process if it exits or is killed. The limit is 2, so you can try killing of the processes twice, which will tell Upstart not to start ...


1

For your MySQL databases, you must first dump the data using mysqldump, transfer the dump and then insert it into the backup system (mysql << my_dump) Alternatively, you could use replication (see: http://dev.mysql.com/doc/refman/5.6/en/replication.html) but I guess it would be overkill in your case.


1

To reset your mysqld password just follow these instructions : Stop the mysql demon process using this command : sudo /etc/init.d/mysql stop Start the mysqld demon process using the --skip-grant-tables option with this command sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & Because you are not checking user privs at this point, ...


0

Versions should not coincide This is the two different project MySQL Connector/J and MySQL. In my case MySQL version is: mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (i686) using readline 6.2 and mysql-connector-java: <dependency> <groupId>mysql</groupId> ...


-1

The SSL startup options should be near the top of your my.cnf file or they might be ignored. I had problems running mysql 5.6 on RHEL 6.4 where the SSL variables were being ignored, I had them at the end of the my.cnf file. I moved them at the top of the file (just below [mysqld]) then I restarted the server and everything was fine.


0

Login to webmin and under servers, access the mySQLdatabase server.You will then be able to set the (user) password provided you have: mysql -u (**user**) -p < /usr/share/doc/rsyslog-mysql-5.8.10/createDB.sql. The web gui is easy but to be secure use the terminal. cheers.


0

A much more reliable way to create an ssh tunnel to a remote mysql database is to use gstm, the Gnome SSH Tunnel Manager... sudo apt-get install gstm Then run the gui application, create a named config for your connection, with host set to destination host and port set to 22 (probably) as the ssh port. Tick autostart if you want this tunnel to auto-launch ...


1

Without wandering into the unknown territory of compiling packages yourself, the best solution here is to find and add a PPA (which is a "personal" repository) which hosts these packages. Luckily for you, there are PPAs for all your packages, maintained by debian packagers / maintainers: PHP 5.5: https://launchpad.net/~ondrej/+archive/ubuntu/php5 ...


0

My 14.04 server install only needed (after php5-mcrypt installed) sudo php5enmod mcrypt sudo service apache2 restart


1

How to restore the root user Stop MySQL and edit /etc/my.cnf to contain skip_grant_tables: [mysqld] skip_grant_tables Then restart MySQL with /etc/init.d/mysqld restart. Start the MySQL CLI: [root@test ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.0.77 Source distribution Type ...


0

Try this, changing the directory if necessary. A symbolic link might need to be created. From the terminal: sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin



Top 50 recent answers are included