Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
128 views

Strange message now appears when I open up my terminal

I was recently installing MySQL and everything seemed to go just fine, however, when I opened up my terminal to test a few things out, I got a strange message: No command '“alias' found, did you ...
0
votes
0answers
9 views

Ubuntu mysql workbench menu shows doubled

I install mysql-workbench in ubuntu 14.04 LTS software center. It install mysql workbench version 6.0.8. In this, menu is doubled So I decided to upgrade the mysql workbench version and add a ...
0
votes
1answer
8 views

MediaWiki installation error: MySQL not identified

After following this answer mysqladmin error while attempting to install MediaWiki on 14.10 I received this error: http://i.imgur.com/Es6oA6G.png. I have been recommended to do: local mysql.so and ...
0
votes
0answers
12 views

I can not connect ot my databse

I have a php connection code as below and i wanna connect to my db_shop database, but when i use localhost/MYshop/index.php on the browser it pop up as below message mysql_connect(): Access denied ...
2
votes
3answers
381 views

Are Apache, PHP and MySQL installed by default?

Are the Apache server, PHP, and MySQL installed by default when you install Ubuntu 13.10, or should you install them separately later?
0
votes
1answer
7 views

Host local database using ubuntu for external applications

I am trying to build an Android application and I need to install a database to store all my data like users, passwords etc. This is the first time when I do something like this and I dont have a clue ...
0
votes
1answer
12 views

Trying to Secure MySQL Replication

I'm trying to do Secure MySQL Replication on my VPS with Ubuntu 14.04. I follow these steps (read only Step 1: Setup SSH Tunneling): ...
-1
votes
2answers
155 views

How to install ownCloud 8.0.0 in Ubuntu 14.04?

I am following this link to install ownCloud in Ubuntu 14.04 and faced following errors. PHP modules have been installed, but they are still listed as missing?Please ask your server administrator to ...
0
votes
1answer
22 views

mysqladmin error while attempting to install MediaWiki on 14.10

I've been following this installation guide for MediaWiki on Ubuntu (https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu#Step-By-Step) and I managed to get up to Configure MySQL->Regular ...
0
votes
1answer
11 views

Make command run when MySQL database connection is made

I have successfully set up an AMP server (Apache, MySQL, and PHP) and have installed my Content Management System (Joomla!), which I am using to make a small website. The CMS connects to MySQL ...
0
votes
1answer
86 views

MySQL not starting in Xampp

I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order): sudo chmod 755 /opt/lampp/etc/my.cnf sudo chmod -R ...
1
vote
2answers
433 views

Auth succeeded No requires line available

Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess; Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely: <Directory ...
0
votes
0answers
19 views

Verifying the Current Version of PHPmyAdmin and Updating if Not

A question was asked on this forum concerning having the latest versions of MySQL, Apache, and PHPmyAdminn. In reviewing this question, I followed up on PHPmyAdmin to verify whether I had the latest ...
-1
votes
1answer
18 views

Where is save data base made in mysql-workbench?

I want know where are saved by default the data base made with mysql-workbench. I want know the directory.
0
votes
1answer
17 views

Trouble in configuring mysql in ubuntu

while trying to configure mysql in ubuntu i got the followig error I tried reconfiguring but it wont work PLease help me on this
5
votes
6answers
16k views

dpkg: invoke-rc.d: initscript mysql, action “start” failed

I have read a number of the posts here and they all state to run the following commands: Apt-get -f remove ** apt-get update apt-get upgrade apt-get -f install ** I have seen these in various ...
0
votes
0answers
9 views

On connecting to MySQL via SSL getting ERROR 2026 (HY000): SSL connection error: protocol version mismatch

I am working with MySQL and generated the certificates to use with MySQL to enable SSL. Here are SSL configs: mysql> show variables like '%ssl%'; +---------------+----------------------------+ | ...
0
votes
0answers
5 views

Every few days the VPS maxes out all it's resources and has to be cold restarted. Methods to narrow down the reason?

CPU load, memory usage, apache usage, mysql usage peak at the same time to incredible values making even logging in via SSH impossible and the server has to be restarted from the hosting interface. ...
0
votes
0answers
15 views

How to shut down (or stop) Apache and My-SQL servers from my LAMP setup? [duplicate]

I just followed the fool proof instructions on how to set up LAMP server on Ubuntu (here: http://howtoubuntu.org/how-to-install-lamp-on-ubuntu). Now I need to know how to not have it running all the ...
0
votes
0answers
8 views

How to configure my LAMP server to POST form data to database

I have installed LAMP server on Ubuntu. I've got apache configured and running just fine. I think my problem is somewhere in the configuration of PHP or SQL.... as I have very little experience in ...
0
votes
0answers
11 views

ISPCONFIG Ubuntu 14.04 phpmyadmin 404 Not Found

After following this tutorial https://www.howtoforge.com/perfect-server-ubuntu-14.04-apache2-php-mysql-pureftpd-bind-dovecot-ispconfig-3-p4, and successfully completed when i try to acces phpmyadmin ...
1
vote
2answers
5k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
4
votes
2answers
8k views

'Unable to set password for the MySQL “root” user' on a Openvz VPS

I'm trying to install mysql server on my Openvz based VPS running Ubuntu 13.04 64bit and i keep getting this error at the install. I tried multiple times and i also re installed the os with no change ...
0
votes
2answers
6k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode. Now that ...
24
votes
15answers
43k views

Can't start mysql - mysql respawning too fast, stopped

Today I did a fresh install of ubuntu 12.04 and went about setting up my local development environment. I installed mysql and edited /etc/mysql/my.cnf to optimise InnoDB but when I try to restart ...
0
votes
0answers
20 views

DOVECOT: Access denied

I am trying to set up a mail server following this tutorial: http://www.starbridge.org/spip/spip.php?article12#dovecot-sasl-lda-imap-et-sieve I cannot receive emails on my email client (thunderbird). ...
0
votes
1answer
56 views

mysql-server fails to install after previous failure (and start, and thus configure)

Ubuntu 14.10 64bit sudo apt-get purge mysql-server-5.5 mysql-common && sudo rm -r /etc/mysql Now that we are uninstalled sudo apt-get install mysql-server Reading package lists... Done ...
0
votes
0answers
22 views

Ubuntu 14.04 phpmyadmin : “Login without a password is forbidden” error

I searched lots of Questions and answers here and i applied the solution too. I edited config.inc.php and commented $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; too ,then I restarted apache server ...
1
vote
1answer
11k views

How to deal with MySql ERROR 1133 (42000): Can't find any matching row in the user table?

I am constantly get the following error message: 1045 Cannot log in to the MySQL server I have tried the following: sudo service mysql stop (Went fine) sudo /usr/sbin/mysqld ...
3
votes
1answer
108 views

MySQL (InnoDB) shutsdown same time every day

Ok so recently pushed a large update to my project onto my Ubuntu 14 server. Up until now it's been stable however since the push at exactly 00:36 GMT each day mysql is killed!! Not ideal as we need ...
0
votes
1answer
5k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
0
votes
2answers
24 views

How to reset mysql root password without logging into mysql?

I want to reset mysql root password but I don't want to log into mysql and then reset the password just as follows, mysql -u root FLUSH PRIVILEGES; SET PASSWORD FOR root@'localhost' = ...
29
votes
8answers
52k views

Mcrypt extension is missing in 14.04 server for mysql

The php mcrypt extension on ubuntu 14.04 shows that it is installed properly, but phpmyadmin says: The mcrypt extension is missing. Please check your PHP configuration. My current php config is ...
0
votes
1answer
3k views

Unable to Login as root after mysql service restart

I installed mysql on Ubuntu 14.04 LTS like: sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql after completely removing mysql with: sudo apt-get remove --purge mysql-server ...
3
votes
1answer
6k views

“Can't create test file /var/lib/mysql/user-desktop.lower-test”: How to run mysql server on Xubuntu 13.04 (kubuntu-desktop)

I have downloaded and unpacked MySQL 5.6.12 to /opt/mysql/server-5.6. I want to use this db instead of pre-installed 5.5 version. But neither version works. When I want to start a server with mysqld ...
0
votes
2answers
23 views

Trying to enter mysql prompt

I have install MySql and now i am trying to get into the prompt of mysql with this command: mysql -host localhost -p but I am getting this error ERROR 2005 (HY000): Unknown MySQL server host ...
0
votes
3answers
76 views

Import error :No module named MYSQLdb

I have a problem so a connection a python to database local of MySQLdb. Message of error is: import MYSQL ImportError:No module named MYSQLdb. This is a script in python 3.4 to connection my ...
0
votes
2answers
435 views

mariadb 10 install error on ubuntu 14.04

when trying to install mariadb on ubuntu 14.04 dpkg: error processing archive /var/cache/apt/archives/libmysqlclient18_10.0.14+maria-1~trusty_amd64.deb (--unpack): libmysqlclient18:amd64 ...
0
votes
0answers
21 views

Can't login in phpmyadmin in ubuntu 14.04

I can't login in phpmyadmin using my root password. Moreover, it is not showing any error message too. When I enter password, it redirects to ...
0
votes
0answers
30 views

Cannot reset mysql root password

I can't login to the localhost phpmyadmin neither to the mysql server as root (through the terminal). On both places I get the #1045 error. I followed this answer but the queries were affecting no ...
0
votes
1answer
219 views

Skipping incompatible error when compiling mysql library using arm-linux-gnueabihf

All problems posted related to mysql library use standard gcc compiler. However, I need to compile a project running on a beaglebone black device. Hence, I am using arm-linux-gnueabihf-gcc instead of ...
1
vote
2answers
3k views

Nohup with mysql command

I need to run in background mode some mysql-query... But how can i do this with nohup? Standartly i do: musql -uroot -p use SomeDb; Select * from blablalba; But how can i do this with launching ...
-1
votes
0answers
11 views

Unable to install mysql-server-5.6 on ubuntu 14.04 [duplicate]

when i install mysql server on Ubuntu 14.04 san@san-desktop:~$ sudo apt-get install mysql-server-5.6 Output: E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable) E: ...
0
votes
1answer
28 views

mysql does not start automatically

I'd like mysql to start on boot but it does not, because I had removed rc.something (don't remember what was it) previously when I wanted it to not start automatically. Now in order to run it I need ...
4
votes
2answers
2k views

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different ...
1
vote
2answers
7k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm a newbie here so please bare with me. I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be ...
0
votes
1answer
47 views

Linux Ubuntu Mysql issue

I am not sure if something is wrong with my mysql (runing on dedi server). I might have missconfiguared something, or using a wrong port to connect to, or if it's getting blocked. I'm quite new with ...
-1
votes
0answers
12 views

createing a folder in phpmyadmin rootfolder got apache

I am new to ubuntu and recently i installed and working with it(13.04). i've installed phpmyadmin successfully but connected it with mysql . i want to create a folder. so that i can access it as ...
1
vote
0answers
39 views

Something wrong with my terminal

I am trying to run this command apt-get install mysql-server and it sets up the packages but when it reaches a point where a password input is needed, this is the screen i am getting I can't even ...
0
votes
1answer
27 views

MySQL Server keep shutting down

mysql server is keep shutting down, i am using DigitalOcean 512 MB Memory and 20GB Disk. I am running WordPress and iRedMail. Here are my Error Logs: Version: '5.5.38-0ubuntu0.14.04.1' socket: ...