Tag Info

New answers tagged

0

This one is the one you want: /usr/lib/php5/20121212+lfs/mysql.so Uncommenting in this case means removing the semicolon. Whitespaces are not required, so this one: ; extension=msql.so Should become this one: extension=mysql.so (notice the missing y in the original) And this one: ; extension_dir = "./" Should become this one: extension_dir = ...


1

The simplest way to install all three is to run the lamp-server task: sudo apt-get install lamp-server^ The caret at the end means that this is running a task, not installing a package. There is no lamp-server package, so if you leave off the caret, apt-get will return the error message, Unable to locate package lamp-server. The task will install ...


1

LAMP would be overkill. That is intended for hosting a website. If you only need a database you can install MySQL. But that might be overkill too. There is also SQLite (it is a "light" database and I would opt for that). MySQL: sudo apt-get install mysql-server SQLite: sudo apt-get sqlite SQLite is a software library that implements a ...


0

I found my mistake. The problem was in MS Word, I saved all commands in a doc file and just copy and paste them. MS Word does regular - in longer – in some cases. So, this longer dash break my last command: ssh -L 33061:localhost:3306 tunneluser@1.1.1.1 -f -N


-1

try apt-get install php5 php5-mysql apt-get install mysql-server and Remember to restart all services related to Apache server. for complete tutorial following this How To Install OwnCloud 8 on Ubuntu 14.04


0

What i've read on that tutorial is this: This step is not necessary if you were prompted to create a mysql root password during MySQL installation. I recently reinstalled lamp and i remember having been prompted for MySQL root password during the installation. Most likely you have set your password already. If you don't remember having done so, try to ...


0

Probably there are better solutions, and i don't know if this would be an optimal solution for you, but one way to accomplish this would be to simply call shell_exec() after each mysqli_connect(): $link = mysqli_connect('127.0.0.1', 'root', '', 'db'); shell_exec('<command>');


0

Just add AuthMySQL_Authoritative Off to .htaccess


5

MySQL is a database and you're expected to interact with the database through tools (MySQL Workbench, the mysql command line tool, etc.) rather than directly interact with the files on disk. In order to do a backup, for instance, you would do an SQL dump of your database rather than copying the database files themselves. To find the files, run the SQL ...


0

Are you sure that you installing mysql, because the screen says phpmyadmin. Which command do you use to install mysql? sudo apt-get install mysql you can have look at /var/log/apt/term.log there might be more information about the error


0

Seems like no need to do all these purges and removals. All you need to do is to remove the server, and execute: rm /etc/mysql/ -R And then install the server. The idea was from the external link referenced from the answer at this thread: http://askubuntu.com/a/448249/109764


1

In my case the problem was the /etc/mysql/my.cnf file permission. I changed it for cenvenience but it caused erros like kernel: [604528.290448] type=1400 audit(1424350956.727:193): apparmor="STATUS" operation="profile_replace" profile="unconfined" name="/usr/sbin/mysqld" pid=15008 comm="apparmor_parser" The my.cnf permission was 766 and I changed it to ...


0

Installing php5-mysql solved my problem apt-get install php5-mysql service apache2 restart


0

Since you mentioned, it's recommended you have at least 1GB of space free on / in order to have a working system, as for mysql try this: sudo apt-get purge mysql-server mysql-server-5.5 sudo apt-get update sudo apt-get install mysql-server Probably your apt cache is old and it's trying to pull some bad package config. I see that now mysql-server is meta ...


0

I suggest that you need to check the below provided in your server. Whether any cron is running in the server. You can make use of cron job log file to verify that. The log file is at the path : /var/log/syslog Checking the load average at that specific time will also help you if there is any other load consuming process was initiated at that time. You can ...


0

sudo dpkg-reconfigure mysql-server-x.x Replace x.x with your current mysql server version. Than it will prompt for a new password.


0

Try follows: mysqladmin -u root password **your-new-password** sudo /etc/init.d/mysql restart mysql -u root -p Give password to enter mysql.


0

I had the same problem, but I realised that you can't start and use MySQL from XAMPP while it is running. I think you have to stop it first (not using XAMPP command)


0

Seems like ost was not defined in /etc/hosts (assuming that's what your using for -host based on error) Would be something like ost 192.168.1.x To be sure this is the problem, you can try to connect with ip address, rather than hostname and if that works, just edit /etc/hosts As directed, with proper address


2

Your command line should be: mysql --host=localhost -p From the mysql man page: · --host=host_name, -h host_name Connect to the MySQL server on the given host.


0

As far as I know, MySQLdb does not support Python 3. From the page '[MySQL-python]'1 updated on 2013-06-08: * Python versions 2.4-2.7; Python 3 support coming soon. mysqlclient-python (https://github.com/PyMySQL/mysqlclient-python) claims support for python 3 but I have no experience with that product. Personally, I use pyodbc (also requires libmyodbc) ...


0

Unfortunately MySQLdb does not support Python 3. You basically have two options: Run your script using python2.7, that way you won't need to change the MySQL module. The downside is that you'll probably have to convert some code to python2.x. Look for python3.x supported modules as explained here: Python 3.4.0 with MySQL database.


0

You have to install the module with: sudo apt-get install python-mysqldb Reference: This thread on SO


0

For those in Ubuntu 14.10 upgrading from MySQL to Maria DB, I would find this as one answer from Google searches. I would get stuck in 14.10 also with a similar libmysqlclient18:amd64 10.0.16+maria-1~utopic (Multi-Arch: no) is not co-installable with libmysqlclient18 which has multiple installed instances After following these suggestions to no avail, ...


0

You must first remove these options because your linker is trying to find in these paths (which clearly have not the .so files): -L/usr/lib/mysql -L/usr/lib and find and copy these files from your BBB to your machine: libmysqlclient.a libmysqlclient.so ld-linux.so.3 ld-linux-armhf.so.3 libmysqlclient.a libmysqlclient.so libz.so.1 then add -L these files ...


0

Thanks this helped However, I needed to enter a password after the command, so I did the following: $ nohup mysql -u [username] -p [database_name] -e "[sql_query]" Enter password: Since I couldn't successfully run the command in the background, after entering the password at the prompt I closed my connection (by closing my remote console). I opened up ...


1

The command you are looking for is probably sudo update-rc.d mysql defaults /etc/init.d/mysql Default script: #!/bin/sh -e # upstart-job # # Symlink target for initscripts that have been converted to Upstart. set -e INITSCRIPT="$(basename "$0")" JOB="${INITSCRIPT%.sh}" if [ "$JOB" = "upstart-job" ]; then if [ -z "$1" ]; then echo ...


0

Your MySQL server is not configured for access over the network, which is the default, for security reasons. Please see the help in the configuration file to configure the service for access through the network. The reason the game server does not see the MySQL server is that the game server tries to access the database over the network; it does not try ...


0

Take a look at this Stack Overflow question (or this Database Administrators one), it deals with the exact same situtation. The amount of RAM seems too small for MySQL, you will need to configure your DB server and possible your webserver too. Also, if you do not have a swap partition, you should have one, if it is possible. Another piece of advice: you ...



Top 50 recent answers are included