Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
9 views

Asking for a sudo password in advance

I have some scripts for backing up data. Some of them need root access, so I use them with sudo. However, sometimes I get confused, e.g. for the mySQL backup, which also needs a mySQL root password. ...
-1
votes
0answers
12 views

Installation of mysql server 5.6 on ubuntu 14.04

I am using Ubuntu 14.04 on vwmare workstation version 7. I have been trying to install mysql, flex and bison on ubuntu from a very long time. I always get a common error irrespective of any ...
1
vote
1answer
16 views

MySql won't start after installation on Ubuntu server 14.04.1

I'm new to Ubuntu server and MySql. I'm attempting to create a server in VirtualBox that I can use for web development and testing before deploying to a real server. I have Ubuntu server 14.04.1 ...
-1
votes
1answer
28 views

phpMyAdmin doesn't work when installing from repo

I've just installed phpMyAdmin via apt-get and rebooted. When i enter '127.0.0.1:3306' into web browser, i get something like this: I'm totally new to mysql but quite experienced with linux. How ...
0
votes
0answers
9 views

access denied from local host

Ok, I've set up my server and have been having fun designing my website. At the moment I've got several php files that access my MySQL databases. everything is ok client side and the php has no ...
-1
votes
0answers
13 views

LOAD data within CURSOR in MYSQL [on hold]

I need to make several tables from CSV files, and would really like it if I can do this with a query on MySQL. The current program's general code is this: LOAD DATA LOCAL ...
0
votes
1answer
18 views

What is my phpmyadmin's url?

I'm a newbie with linux ubuntu and phpmyadmin. I had an url to access phpmyadmin thru the webbrowser, but since i did not use it for like a year now, i can't remember the url. I believe it was ...
0
votes
1answer
24 views

mysql -h slow ?? how I can correct this?

I have 3 server .1 database server(mysql as database) and 2 normal server called A and B. from A when I try to connect database using the bellow command,the connection is set within a second mysql ...
0
votes
0answers
12 views

my browser is downloading .php files instead of loading them [duplicate]

i already have install all the softwares like apache 2, mysql, php5, phpmyadmin, database. but my browser is just downloading .php files instead of loading them, and on loading localhost/phpmyadmin. ...
0
votes
0answers
7 views

Should I have any concerns when updating my LAMP-server?

I'm using Ubuntu server 14.04 LTS. I'll be installing lamp server with tasksel, though I don't know much about tasksel other than It Is a synaptic package manager. Though, I won't be changing up the ...
0
votes
0answers
20 views

DBI failed to connect mysql

I encountered DBI connection failure to mysql when I tried to install and configure the orthoMCL programs. I would appreciate very much if you can help diagnose and advise some troubleshooting tricks. ...
0
votes
1answer
28 views

mysqld is suddenly taking too much memory and my laptop is getting hotter

I have been using ubuntu 14.04 for a while but really new to linux command line stuffs. I mainly use it for Java/android/web development purposes. Sometimes I notice my laptop gets more hot than ...
-1
votes
0answers
29 views

Is there any annotation available for eager loading at class level?

Is there any annotation available for eager loading at class level when we are not using any mapping ? Because, I know that this is available in XML configuration where we have .... (I know ...
-1
votes
0answers
18 views

How to clean/wipe mysql installation on Ubuntu?

I lost a root password to mysql and wanted to retrieve it. Now I'm fed up and just want to wipe MySQL and reinstall. Nothing works. How do I uninstall Mysql? to supposedly uninstall mysql, the ...
0
votes
1answer
25 views

mysql_config_editor not included in MySQL APT Repository?

I've installed MySQL from MySQL APT Repository. Now I want to run "mysql_config_editor" to encrypt my .mylogin.cnf, but it displays: The program 'mysql_config_editor' is currently not installed. To ...
0
votes
1answer
23 views

What path shall I find schema.sql?

I am looking for file named "schema.sql", can someone let me know where can I find it? when I googled a little about it I go one path i.e. /etc/raddb/sql/mysql/schema.sql however it does not exists ...
0
votes
0answers
39 views

MySql crashes happening daily after ubuntu system updates

I have been having this issue for sometime and have no idea why it happens or how to fix it. I'm a Linux novice so that doesn't help. I have a server running on AWS and s used only for hosting ...
-2
votes
0answers
15 views

How to install LAMP in ubunatu 13.04 i386 from packages offline? [duplicate]

How to downloads right packages please i have lost 2 time my data to install lamp...please help me easy way
0
votes
0answers
37 views

Does VM require Swap? su: fork: Cannot allocate memory

We have Mysql Server in AWS environment in Ubuntu 14.04. Recently our server lost new connectivity like ssh, or scp any connections due to cannot allocate memory. And my existing connectivity to ...
1
vote
1answer
50 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 ...
0
votes
1answer
19 views

Not installing softwares after changing the server

I changed the download server from sri lanka server to US server using software and update window. Then I tried to install mysql using this command. sudo apt-get update sudo apt-get install ...
0
votes
1answer
41 views

I am not able to install mysql on ubuntu after unistalling it

I have to install MySQL in Ubuntu for a class. The first time intalling mysql it worked perfectly. However, I accidently ran the sudo mysql_secure_installation command when I wasn't supposed to. I ...
0
votes
3answers
154 views

Postfix/ Dovecot and MySQL

I have an issue in authenticating users using postfix/ dovecot with mysql at ubuntu LTS. Outlook connected to the server but got error for authentication. below is posfix configuration settings: ...
3
votes
0answers
78 views

I can't deploy mysql to LXC:0 with juju

I used "juju deploy --to lxc:0 mysql" to deploy mysql. But ,the container start failed.--"error: container failed to start" so,I used dmesg to look error message: [1318582.474759] init: ...
0
votes
0answers
31 views

MySQL Workbench do not render Columns Tab at ER

I have a fresh install of Ubuntu 14.04, after installing all I need, I started MySQL Workbench (v.6.1.7 build 1788) and in it's ER modeling its not showing anything in Columns Tab when editing a ...
0
votes
2answers
54 views

How to stop mysqld process?

result of ps -e | grep mysqld running htop and clicking on memory usage.. It is taking 33% of 4gb memory. I just want to end the mysqld process.. running sudo pkill mysqld ends the process but ...
0
votes
2answers
60 views

ERROR 1045 (28000) on mysql-server installation [duplicate]

I am new to Ubuntu trying to install MySQL. sudo apt-get install mysql-server php5-mysql then to create database directory structure sudo mysql_install_db Then to secure I use sudo ...
2
votes
1answer
29 views

Trying to sync live data to a backup server

I'd like to take the data from the live system to a backup system (to test new features etc) Piecing together an rsync command, I have the following. How do I ensure everything is copied? Things ...
0
votes
1answer
80 views

What version of “mysql-connector-java” to include in pom.xml for ubuntu 14.04

The mysql server version installed is 5.5.38 as verified by sanchit@sanchit-3560:/$ mysql --version mysql Ver 14.14 Distrib 5.5.38, for debian-linux-gnu (x86_64) using readline 6.3 But in the ...
0
votes
1answer
76 views

How to upgrade softwares from currently installed LAMP on Ubutu 12.04 LTS system? Please provide me the step-by-step instructions

Someone had installed LAMP on my machine almost two(2) years back. I got this machine since last six(6) months. The LAMP is working fine for all of the PHP project work I do. But the issue is all the ...
0
votes
1answer
45 views

How to access MySQL after deleting all MySQL users?

I deleted all users by mistake and now I can't access MySQL. I searched too much but I can't access MySQL I can't remove it && reinstall again I delete all users from table user from database ...
0
votes
1answer
252 views

phpmyadmin not found

I am using ubuntu 14.04. I have made setup LAMP by going through step by step what in this link. For apache I mean http://localhost all the files are working fine . But when I am doing ...
0
votes
2answers
274 views

Forbidden You don't have permission to access /phpmyadmin on this server

I installed php, mysql, phpmyadmin on my Ubuntu 12.04 localhost in the following steps: I try these steps: sudo apt-get install apache2 sudo /etc/init.d/apache2 restart sudo apt-get install php5 ...
1
vote
1answer
71 views

Error installing mysql server on Ubuntu 14.04

I am getting error installing mysql on ubuntu desktop 14.04 ( 64-bit) I used following command sudo apt-get install mysql-server It asked me for password ( and verfication ) and ended on follwing ...
0
votes
0answers
147 views

MySQL Workbench on MySQL 5.6.19

I tried to install MySQL Workbench 6.1.7 on Ubuntu 14.04 after installing Mysql 5.6 library, but get the following: error: Package dependencies cannot be resolved This error could be caused by ...
0
votes
0answers
22 views

JUJU - deployed wordpress and mysql - Error establishing a database connection

After a week of deploying wordpress on juju with mysql, the site has gone down with the error: "Error establishing a database connection". Juju status is not working at all and I can't seem to ssh on ...
0
votes
0answers
168 views

Apt-get unmet dependencies

I´m using Ubuntu Server 12.04 and MySQL 5.5. When I try to install libsml2-dev I get the following message : root@myserver:/usr/local/php5516/php-5.5.16# apt-get install libxml2-dev Reading package ...
-1
votes
1answer
87 views

Database error. Wordpress. MySQL have shut down at 10:00 am

Could you please tell me what's wrong with my MySQL? Ubuntu 14.04. I can't understand what's going on.. 140912 10:00:55 [Warning] Using unique option prefix myisam-recover instead of ...
0
votes
2answers
261 views

“Rejected send message, 1 matched rules; type=”method_call“, sender=”:1.5“” while starting MySQL

I have a mysql that has been working fine but now will not start. All I've been able to accomplish is using sudo start mysql which generates the following error: start: Rejected send message, 1 ...
2
votes
1answer
69 views

Using libreoffice base as GUI for MySQL database (os- ubuntu 14.04) [closed]

I have been trying to deploy one of my projects that uses jsp for the front end, tomcat7 for the server and a mysql database. I tried integrating the mysql database with the libreoffice database ...
0
votes
0answers
40 views

PhpMyAdmin wont let me log in without password

I am preparing a Vagrant box to develop websites and I wanted to install phpmyadmin, to log in just as "root", no password needed, since it is just for development, but whenever I try it, I get the ...
0
votes
0answers
140 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
votes
3answers
83 views

What Is the Best UBUNTU script for installing LAMP [duplicate]

I have tried to install LAMP on Ubuntu 14.04LTS Cant get PHPmyAdmin to work and access MYSQL Where is the clearest set of instructions to install LAMP
0
votes
0answers
8 views

Remote access times out after update

Here is the situation: I have a MacBook which I use for all of my development and an Ubuntu server running a LAMP stack for my website. I've only had Linux anything for a few days so please bear with ...
0
votes
2answers
154 views

Working SQL client

I managed to get working Apache and everything's fine. Got MySQL running, which is nice. But then it turned out that I had to use terminal for all the SQL commands I had to put inside. I'm not close ...
0
votes
0answers
18 views

UnsupportedClassVersionError with OpenJDK 1.6 and Mysql

Using Ubuntu 13.10 on virtual server hosted by OVH (France), Server version: Apache/2.4.6 (Ubuntu), OpenJDK Runtime Environment (IcedTea6 1.13.3) OpenJDK 64-Bit Server VM (build 23.25-b01, mixed ...
2
votes
1answer
65 views

MySQL: Can only login from command line or as root

I've been trying to solve this problem for the last 3h. I've just set up a MySQL server on my dedicated root server, running Ubuntu 14.04-minimal. I have no problem logging in as root anywhere - it ...
2
votes
1answer
54 views

How can I dump and restore MySQL databases to and from Dropbox from the command line?

I have a few MySQL databases that I would like to sync between two computers. What I'd like to do is be able to have a quick command or script on one computer that I can use to quickly dump the ...
0
votes
1answer
73 views

Is syncing a MySQL database with Dropbox this easy, and is it a backup solution?

Maybe I'm wrong, but I was sure that some time ago when I was looking for a way to sync my MySQL databases using Dropbox, I was told that this was not possible because of the way MySQL works. But I ...
0
votes
1answer
102 views

Installing FOG on Ubuntu 12.04

I am trying to install FOG on 12.04 Server LTS. I have downloaded the latest version from SF, but when I try to install it, it fails when trying to install MySQL, specifically with: The following ...