Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
103 views

Shell Script - How to run script after mysql is ready?

I have a script (in a .sh file) to run once everytime i logged in. But I have to make sure that mysql service is already running before the main script in my .sh executed. Here is my draft: function ...
0
votes
2answers
109 views

Cannot install Apache. Missing Dependencies that will not install

I am trying to install LAMP on my new server. The problem is that I keep getting a error. Here is what it is: root@178658:~# apt-get install lamp-server^ Reading package lists... Done Building ...
0
votes
1answer
428 views

How come I get “mysqld.service failed to load: No such file or directory.”

Following this tutorial, I'm getting # sudo service mysqld start Failed to start mysqld.service: Unit mysqld.service failed to load: No such file or directory.
0
votes
0answers
6 views

Recompile MySQL server with debugging enabled

So I am facing this problem, where I am trying to add the .so file to mysql plugin directory and try to create a function from that file and I just keep getting an error and one of the suggestion to ...
0
votes
0answers
81 views

Trying to connect to MySQL and Flask cannot connect to socket

I have looked through all of the information out there and still can get this to work. I am running the LAMP server version (not client) and I am trying to connect MySQL and Flask using Ubuntu 14.04. ...
0
votes
0answers
26 views

Can only connect to mysql server through 127.0.0.1

I have a mysql server running (lamp+ispconfig3). But it's kindof broken; I can only connect to it through '127.0.0.1' if i use localhost i get Can't connect to local MySQL server through socket ...
0
votes
0answers
17 views

mysql install via apt-get - password? [duplicate]

When I did an ubuntu 15 install I don't recall setting the mysql server's root password. Now tying to log in - mysql -u root -p I'm asked for a pass. I recall some screen that popped up asking to ...
0
votes
0answers
16 views

Problem about username and password regarding phpmyadmin

Sir I wrote http://localhost/phpmyadmin to access phpmyadmin but getting some error.I attatch a screenshot.enter image description here so help me out from this problem.
0
votes
0answers
87 views

problem to install phpmyadmin in ubuntu 14.04 64 bit

I am trying to install phpmyadmin sudo add-apt-repository ppa:nijel/phpmyadmin sudo apt-get update sudo apt-get install phpmyadmin But when I used to check the status it shows unrecognized service. ...
0
votes
0answers
24 views

Server 14.04 - MySQL server does not start after copy in /var/lib/mysql

I have successfully installed mysql-server and start it. Then because i have old backup from another Ubuntu server 14.04 of the MySQL databases i created a copy for the old ones /var/lib/mysql. Then ...
0
votes
0answers
60 views

slurmdbd service can't connect to MySQL at startup, but succeeds manually

I installed slurm-llnl and slurm-llnl-slurmdbd on a Ubuntu 14.04 workstation. I successfully configured SLURM, but am having trouble with the slurmdbd service and the mySQL database After a system ...
0
votes
0answers
13 views

Setting up Postfix and Dovecot with mysql

I followed a guide on Linode for setting up Postfix and Dovecot with mysql on Ubuntu 14.04. After it's all said and done I can't log in under a local client and I get some startup errors that I'm not ...
0
votes
0answers
66 views

how to export simple txt log file to mysql DB?

how can i export a simple txt file to a mysql DB ? i want to be able to query for certain iformation and for it to be accessbile for those who have no access on server. i found information of ...
0
votes
1answer
33 views

mysql queries in two tier

How to perform the basic MySQL queries using client and data server(Two tier)?? I have tried editing the /etc/mysql/my.cnf file by changing the bind address to 0.0.0.0 then started the mysql and ...
0
votes
1answer
191 views

Easiest way to update Apache, MySQL & PHP on VPS [duplicate]

I purchased a new VPS from bluehost they provided me old version of PHP that's not supporting my website and Its been 1 Week bluehost technical support team refused to do that they are making excuses. ...
0
votes
0answers
28 views

Getting error(ERROR: 1045) during phpmyadmin installation

I got the following error when trying to install phpmyadmin : How can resolve it?
0
votes
3answers
151 views

Can't display images on localhost

I installed Apache2, MySQL, and PHP on Ubuntu. After creating my test.php file I can't see the pictures on this file. Also, I can't save files or images directly in the /var/www/html folder. I have ...
0
votes
0answers
43 views

access denied to mysql through phpmyadmin

I've installed lampp on my ubuntu 12.04. I've reinstalled mysql-server in order to be able to work from the terminal. I've changed the root password from mysql through mysqld. When I tried to connect ...
0
votes
1answer
50 views

Mysql not working properly in Ubuntu 14.04

when I press mysql in terminal this pops up, ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Something weird stuff happened during setting ...
0
votes
0answers
97 views

Can't connect to local MySQL server through socket

Okay this is one of the problems , the previous day i wanted to install owncloud on my ubuntu 14.04 and somehow messed up with MySQL / Apache2 and their config files. Then local host is showing all ...
0
votes
1answer
52 views

MySQL crash, after rebooting cannot access mysql and low screen resolution

I am stuck and need help please. I am a non-expert user and struggling with a crash yesterday. I was running an R script in Rstudio that was accessing data locally from mysql, and Rstudio hung. I ...
0
votes
0answers
44 views

Wordpress Site Can't add new pages or media

I migrated my wordpress site to a new server, and now I'm having an odd problem. WordPress won't allow me to add media or posts. Well, at least it doesn't recognize that it's added. The media actually ...
0
votes
0answers
51 views

apache2 will not start (Unable to connect in browser)

I had installed apache2 on Ubuntu 15.04 and it worked fine, and then I removed it with sudo apt-get purge. After removing I reinstalled it , but it doesn't work. Opening http://localhost/ in a ...
0
votes
1answer
83 views

Unit lib-init-rw.mount not loaded?

I'm trying to install mysql but got this error: # apt-get install mysql-server E: dpkg was interrupted, you must manually run 'dpkg --configure -a' to correct the problem. # dpkg ...
0
votes
0answers
19 views

My Server IP is redirecting to /mail

Recently, I installed iRedMail and Round cube on my server. As it was using 90% of my RAM, I just backup "www" folder and re-installed the operating system. After that, I again backed up my www ...
0
votes
1answer
26 views

Unmet dependencies preventing installing anything else

I was trying to install gSTM (a tunnel manager) because of some error in MySQL workbench but for some reason it has not worked and now I have a bunch of unmet dependency errors which arise when I try ...
0
votes
0answers
53 views

How to free space on AWS Ubuntu 12.04.5 Instance

Firstly, while similar I do not believe my question is not a duplicate of other questions on this topic because all the suggestions in those questions have not resolved my problem. I have a instance ...
0
votes
1answer
14 views

How can I transfer the users from an old mysql install with having access to ONLY the physical files?

So, I had crashed my server into a non-bootable state. I reinstalled, but not before grabbing the /etc,/usr, and /var directories. I reinstalled mysql on the new install, and was able to copy the old ...
0
votes
1answer
393 views

Problems Removing or installing mysql-server on Ubuntu 15.04 “Vivid Vervet”

I had to reinstall my server and was able to grab the /var, /usr, and /etc directory. Once the server was reinstalled, I installed mysql and phpmyadmin. Afterwards, I tried to put my database files ...
0
votes
1answer
57 views

How can I configure logrotate to SCP multiple log files

I would like to copy multiple files form logrotate, so I try this : /var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/error.log { daily rotate 7 ...
0
votes
1answer
61 views

Problem with mysql workbench in 15.04

My workbench was working just fine before this update. Once I installed the new version I noticed that the management tab was empty and also the server options showed up empty. Initially I thought ...
0
votes
0answers
37 views

Ubuntu 15.04 Stopping mysql in autorun unseccesfull

Tried to stop mysql from autorun, already tested these issues: Systemd Mysql won't stop How to stop mysql from running at boot time? But nothing helped. Every time after reboot I have these ...
0
votes
0answers
174 views

not able to connect to mysql database from oracle sqlplus instant client in Ubuntu x64 15.04

i just successfully installed oracle sqlplus instant client 12.1 in Ubuntu x64 15.04 from https://help.ubuntu.com/community/Oracle%20Instant%20Client and i am able to run sqlplus and sqlplus64 ...
0
votes
0answers
87 views

Restore /var/lib/mysql folders

I am in a bit of a pickel here. I accidentally deleted my /var/lib/mysql directory and tried to recover it using lsof | grep "/path/to/file but it was restored as one data file i.e. var/lib/mysql# ...
0
votes
0answers
93 views

Mysql service is not starting

mysql service is not working, I have tried restarting it using command sudo service mysql restart. I then get the following messages: stop: Unknown instance: start: Job failed to start when I check ...
0
votes
0answers
61 views

Apache2 is running but server not opening in browser

I am able to access using ssh but site is not opening using IP $ sudo netstat -anop | grep apache tcp6 0 0 :::80 :::* LISTEN 29352/apache2 off ...
0
votes
0answers
2k views

Cannot install MySQL

Trying to install MySQL with command sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql Then run this command sudo apt-get install mysql-server libapache2-mod-auth-mysql ...
0
votes
0answers
7 views

Can't Install MySQL Server 5.6, Gettin Error: Unable to set password for the mysql “root” user [duplicate]

Unable to set password for the Mysql "root" user An error occurred while setting password for the mysql administrative user.This may have happened because the account already has a password, or ...
0
votes
0answers
34 views

Ubuntu Mysql Server and Netbense Java Project Connectio Error

@ I Installed Ubuntu Server 14.04.3 LTS (using VMwear Workstation).... Static ip details() address 192.168.137.xxx broadcast 255.255.255.0 network 192.168.137.0 ...
0
votes
0answers
41 views

Why does this folder keep reappearing after I rm -rf?

I'm running Docker on Ubuntu 15.04 and I'm inside a 14.04 container. I have a database called magento. There's no volumes mounted. It has a folder under /var/lib/mysql/magento. I want to rm -rf that ...
0
votes
0answers
325 views

How do you fix “unmet dependencies … but [something] is to be installed” error?

I am trying to install and configure an Ubuntu, Django, and MariaDB stack. I have the latest (as of writing) MariaDB 10.0 installed, and as per the Django documentation regarding databases, I am ...
0
votes
1answer
156 views

How to view the data from a .mysql file?

I have a .mysql database file. I need to open it and view the data. I've MySQL Server & MySQL Workbench installed into my Ubuntu 14.04. Now how do I open the .mysql file and view the data inside ...
0
votes
1answer
96 views

Change location of mysql database

I am trying to move the location of a mysql database. I tried to follow the instructions here and elsewhere, which say to change the "datadir" directory in "/etc/mysql/my.cnf". My problem is that ...
0
votes
0answers
28 views

phpmyadmin and red5-server

I'm a new ubuntu user. I installed ubuntu 14.04 server, then I installed LAMP package, then I installed java 7. I installed red5-server and phpmyadmin at the end. Now either red5-server is working nor ...
0
votes
0answers
2k views

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection XAMPP

Hi i am intend to connect phpMyAdmin, i have install XAMPP but i change the port using this guide Cannot start XAMPP on Ubuntu 11.10 I use this URL to enter phpMyAdmin ...
0
votes
0answers
101 views

MythTV frontend not starting

I'm in the process of setting up (the first) remote frontend for a new MythTV installation on Ubuntu 15.04. The backend is up and running, channel scans were successful, etc. However, when I try to ...
0
votes
1answer
97 views

Error installing mysql?

I'm trying to install mysql-server php5-mysql phpmyadmin but I'm running into the following error: An error occurred while installing the database: mysql said: ERROR 1006 (HY000) at line 1: Can't ...
0
votes
1answer
200 views

dependency problem mysql-server

I upgrade my server time to time with apt-get update then apt-get upgrade and dont use anything else. but these days I have a problem with mysql-server. apt-get cannot upgrade anything else, it break ...
0
votes
0answers
318 views

I can't connect with remote MySQL server via VPN

Help me pls. I am not an expert in networks. I need make a task, and download data from remote MySQL. Company gave me VPN coordinates of their server: PPTP, IP, username, password. Also they gave me ...
0
votes
0answers
202 views

problem accessing phpmyadmin Ubuntu 14.04 LTS

I've recently fix the problem from apache2 services issue now phpmyadmin is configured, but I can't get access to login panel it shown this phpMyAdmin - Error Cannot start session without ...