Tag Info

New answers tagged

0

Before you start off, use Ubuntu's x86(32-bit image), as this will allow you to use both 32-bit and 64-bit machines. Yes, a 32-bit of the server is also available, just take look at the Alternative Downloads page. Also, I use Lili because its easy and I use Windows for setting up Ubuntu. You can use any other application, although for Method 2, you need an ...


0

Use "aptitude" to solve the problem. sudo apt-get install aptitude sudo aptitude remove mysql-apt-config Now follow the proposed solutions.


0

This error occurs because the package you are trying to download and install requires libstdc++6 >=4.9. The latest version of libstdc++6 available on the Ubuntu 14.04 LTS repositories is 4.8.2-19ubuntu1, which is older than 4.9. I'm assuming that you're running Ubuntu 14.04, because the libstdc++6 package on your computer is stuck at 4.8.2-19ubuntu1. The ...


1

Your unmet dependencies problem is caused by the MySQL APT Repository repository. MySQL Server 5.6 from the MySQL APT Repository requires libstdc++6 >=4.9 however MySQL Server 5.6 (mysql-server-5.6) from the the default Ubuntu repositories requires libstdc++6 >=4.6. When you install the version of MySQL Server 5.6 from the Ubuntu Software Center, it ...


0

libstdc++6 : Depends: gcc-4.9-base (= 4.9.2-10) but 4.9.1-0ubuntu1 is installed The package gcc-4.9-base (= 4.9.2-10) is only available for Ubuntu Vivid. Check this (utopic) and this (vivid). Remove the package mysql-apt-config, installed by these instructions and use mysql-server to get the latest version. sudo dpkg --force-all -P mysql-apt-config ...


0

You need to stop the already installed MySQL server. stop lampp stop the MySQL server by one of these commands: sudo service mysql stop sudo /etc/init.d/mysql stop start lampp again


0

As a follow up on my own question I will elaborate with my experience. I made Shell execution work from PHP, but had major security issues with the solution. That was a MAJOR mistake from my hand that I did not see this at the beginning. To eliminate security risks I made a bash script that looked activated users up in the user table. If the user was active ...


1

I think you forgot to quote: mysql -p -u root -h localhost --pager='less -F' -F gets passed to mysql instead of less when you don't pass less -F as a single string.


1

From man less: -F or --quit-if-one-screen Causes less to automatically exit if the entire file can be displayed on the first screen. So, less -F file.txt will make less exit automatically without showing anything, if the content of file.txt can be displayed on the first screen. Here is a test: $ cat test.txt Hello WORLD! Hallo world! $ ...


2

libqt5sql5-mysql is not a part of the default image. If you wish to use it, you must either install it on the phone (which I assume would require making your image writable) or include it as part of your application. As an example, QHttpServer is not provided by the default image. I use it in Beru, so I build it as part of my application.


1

mysql is the client program. You need to install mysql server which you can connect to. sudo apt-get install mysql-server-5.5 During the installation you will be asked for the root password that will be assigned to the mysql root user. Then you need to start the mysqld service sudo service mysqld start Or sudo /etc/init.d/mysqld start Or sudo ...


-2

If this question is still alive ! in fact the answer is in "...too full...". the message ERROR: The partition with /var/lib/mysql is too full! says the partition is full, there is no more disk free space to be used by mysql when the service started , no more space for /var/lib/mysql to grow. in my case, I simply removed some big files from my "/" ...


3

Databases are preserved if they are in the default location /var/lib/mysql. Having taken a look at the mysql-server-5.5 package there are no commands for deleting this data at all. Generally speaking any files (usually log and data files) created in /var are not touched by package managers. Apt/dpgk specifically keeps track of config files which are ...


0

I did manage to fix it. From a basic install of phpmyadmin these are the steps to allow remote connection. If anyone ever needs it Code out /etc/phpmyadmin/confi.inc.php $cfg['Servers'][$i]['controluser'] = $dbuser; $cfg['Servers'][$i]['controlpass'] = $dbpass; Edit /etc/phpmyadmin/apache.conf 10.0.0.157 is the machine you want to access the myphpadmin ...


0

To answer my own question which Jos partly answered. You should not comment out the bind address line (in /etc/my.cnf). Instead, you should point it to the server's IP address, i.e. 10.0.0.40, and restart MySQL. That combined with GRANT ALL PRIVILEGES ON *.* TO ‘https’@’localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; instead of GRANT ALL PRIVILEGES ...


0

if you execute netstat -an | grep 3306 do you see an entry with LISTEN for port 3306?


0

Is the service started? If not (or you're not sure), run: sudo service mysql start


0

When I have had the similar issues with Phpmyadmin, I followed this awesome guide and fixed everything. Follow each step there, you might have missed something.


1

can i execute shell commands on Ubuntu from PHP, and automate what I am doing manually now? You can run shell commands from within PHP using the shell_exec() function or using the ` ` (backtick) operator: if you're running PHP < 5.4.0, first make sure to disable safe mode, then in your PHP script you can use either of those syntaxes: $return = ...


1

This error occurs because the mysql-community-client package you are trying to download and install requires libstdc++6 >=4.9. The latest version of libstdc++6 available on the Ubuntu 14.04 LTS repositories is 4.8.2-19ubuntu1, which is older than 4.9. I'm assuming that you're running Ubuntu 14.04, because the libstdc++6 package on your computer is stuck ...


1

You can try sudo apt-get install -f mysql-workbench I use in such cases aptitude sudo apt-get install aptitude and then sudo aptitude install mysql-workbench Suggestions are made that can help solve your problem.


1

Fixed, apt-get install xdp-user-dirs apt-get install glib_networking


2

phpmyadmin should run on the server that has Apache2 and PHP running, but it is able to connect to an external database server. Answer taken from here: In the config file, change the "host" variable to point to the external server. The config file is called config.inc.php and it will be in the main phpMyAdmin folder. There should be a line like this: ...


0

If you look closely, the menu is not actually doubled. It is actually two separate menus. The first menu is specific to the MySQL Connections home page. The second menu is specific to your open database connection. For example, if you open mysql-workbench, at first you'll only see one menu. Then, if you open a database connection and display an SQL ...


2

The MySQL server cannot start for some reason, this reason should be detailed in the MySQL error log, try tailing /var/log/mysql.err for further information. I've had this happen when some sort of post upgrade action is required. Without seeing the corresponding log entries however, this would be hard to diagnose.


1

Well then check if mysql is really not running: sudo aptitude install nmap And then: sudo nmap -sS <ipofdbserverhere> You can also install the tool on the mysql server, the the command would be: sudo nmap -sS localhost In both cases your answer should look like this. [simmel]@[mars]$ sudo nmap -sS 172.16.1.41 Starting Nmap 6.40 ( ...


0

Which version is your wordpress installation? If it is >= 3.9 read this: https://make.wordpress.org/core/2014/04/07/mysql-in-wordpress-3-9/ In WordPress 3.9, we added an extra layer to WPDB, causing it to switch to using the mysqli PHP library, when using PHP 5.5 or higher. For plugin developers, this means that you absolutely shouldn’t be using PHP’s ...


0

I had the same problem on Ubuntu 14.04 Trusty. Disclaimer: I'm not an expert on this, but this is what I did to get it installed. I think the library needed is libperconaserverclient18.1-dev. Having installed this, the mysql2 gem installation got further, but I got the following error: ERROR: Failed to build gem native extension. In the logs I saw: ...


0

Restricting the user to those services isn't the sort of thing you do at the kernel level. If you want to prevent the user from running programs besides PHP &c, the easiest way is don't have those programs on your system.


1

I've found the same issue on a fresh install of 14.04 without MySQL on Hyper V (Win8). As with 12.04, switching to static memory fixed the problem.


1

Yes there is. For those who have multiple databases lets say 50 - 100, entering it one after the other will be pain staking You will have to create a bash/shell file i.e file with ".sh" extension, after which you will make it executable by changing it mod chmod 777 <file_name>.sh then enter your code above with this few alterations; what we are ...


0

PHP is integrated into apache upon installation and so, there is no need to worry. You can put php code into .php files into the web server. Foe example, instead of using index.html, you should use index.php so you can put php code into it. Here's a sample piece of code that can be used and easily understood - <!DOCTYPE html> <html> ...


0

Although I remember doing all of these steps I must have missed some here and there. This resolved my issue http://stackoverflow.com/questions/25244606/completely-remove-mysql-ubuntu-14-04-lts


0

You do not add these to eclipse - they run independently as servers (apache/php and mysql) Download and install eclipse specifically built for web development from PHP Development Tools.


0

I solved the problem in the following way: chown -R mysql:mysql /var/lib/mysql mysql_install_db --user=mysql -ldata=/var/lib/mysql/


0

I found that you have to edit the file /etc/mysql/my.cnf and make the bind-address the ip address you would like to give access to. And if you would like all you write 0.0.0.0


0

Best and easy LAMP installation tutorial.... http://11howto.in/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04/1425/


0

I am not sure what was the case for me, but the other solutions did not work, it kept giving an error. I tried this apt-get purge mysql-*, then autoremove and autoclean. After that installation was fine. ** Be sure to backups your databases, the above command might delete them as well **


0

Thanks to some help from the [H], I was pointed to the fact that I'm using dynamic memory management in Hyper-V, and that it does not work so well with linux operating systems. http://hardforum.com/showthread.php?t=1856145 https://lkml.org/lkml/2014/12/2/662


0

Anything in the log file? less /var/log/messages less /var/log/syslog As for me, first time over at Digital Ocean I burned myself not setting up a swapfile and with the 500mb RAM I quickly learned that this was needed. (e.g. services/server crashed) Maybe you have more memory available, still worth checking. You can check with: sudo swapon -s If this ...


0

Assuming that the server allows remote access, from Mysql.com: MySQL :: MySQL 5.0 Reference Manual :: 4.2.2 Connecting to the MySQL Server, run this command: mysql --host=<mysql_server_ip_address> --user=<mysql_username> --password <mysql_database_name> If the server doesn't use the default MySQL port (3306), append the --port argument ...


0

Use this command mysql -u <username> -p -h db4free.net


0

about the unknown job, mine solved using this sudo /etc/init.d/mysql start instead of this sudo service mysql start Here where I refer


0

First of delete the user created sudo deluser mysql sudo delgroup mysql then stop the processes of the mysql sudo service mysql stop #or mysqld sudo killall -9 mysql sudo killall -9 mysqld sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autocleansudo deluser mysql ...


0

Use the command below to change the root password for mysql server sudo dpkg-reconfigure mysql-server-5.5


0

Another problem might be that the client you are using is not setting the Message-ID header. To fix that with dovecot use: always_add_missing_headers=yes Funny thing is, in my case it was the GMail mobile client for android which has this behaviour and failed to send mails to *@gmail.com


1

Fairly old question, but still relevant on searches. phpMyAdmin uses plain PHP for config files, and the $cfg['Servers'] array to get the configured servers. So the proper way is to add a new config file in /etc/phpmyadmin/conf.d for every server you want to add. It's only required to end the files name in .php to get them included, but it's a good idea to ...


2

It sounds like the /tmp folder has the sticky bits set This means your permission is denied due to protected_symlinks When protected_symlinks is set to "0", the symlink following behaviour is unrestricted. When set to "1" symlinks are permitted to be followed only when outside a sticky world-writable directory, or when the uid of the symlink and follower ...


1

One trick is to load the whole database into a RAM disk, if it fits. First, create a disk in memory: mount -t tmpfs -o size=350M tmpfs /var/tmp/ramdisk Adjust size as needed. Then move the database to this disk: rsync -av /var/lib/mysql/* /var/tmp/ramdisk/ chown -R mysql:mysql /var/tmp/ramdisk Then start the database server. In my.cnf you point the ...



Top 50 recent answers are included