Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
100 views

MySql - can i make a new connection in windows calling a linux ip address

So trying to figure out if i can use workbench in windows 2008 server and ask it to connect to a linux machine over my network. the reason behind this is my frontend application is in windows however ...
0
votes
0answers
261 views

Cannot install (configure) mysql on Ubuntu 14 server using apt-get

When installing mysql-server-5.5 on Ubuntu 14, I get the latest mysql-server with: sudo apt-get install mysql-server Which asks to install mysql-*-5.5 packages. I am then prompted to give a ...
0
votes
0answers
191 views

Cannot create a new connection in MySql Workbench

Cannot create a new connection using workbench using ubuntu The message is "Failed to Connect to MySQL at 127.0.0.1:3306 with user root" Can somebody please help me.
0
votes
0answers
22 views

problems while creating procedure in sql

whenever i create procedure in sql it always gives me the result as "procedure created with compilation errors" I am using oracle 10g.I don't know what should I do overcome this.
0
votes
1answer
175 views

Ubuntu 14.04 Error when compile PHP 5.6.3

I did everything right with the installation of all dependencies for Apache2 and PHP i think. First I installed a clean Ubuntu 14.04 with all actual updates. Then I installed with "apt-get build-dep ...
0
votes
2answers
82 views

Permission denied when trying to upload to /var/www

I made a Website which i want to publish right now. I asked someone if he could host it and later i got an e-Mail telling me it is all set up. Including a Admin Name and Password and also a MySQL root ...
0
votes
0answers
52 views

Backup database with mysqldump

Hello i use mysqldump with crontab for save my database each hour but after one day i have 24 files What is solution for auto delete if more 5 files ? And what is chmod for folder backup for security ...
0
votes
1answer
26 views

MySQL starts run manually with datadir param, but doesn't as a service

Why does sudo service mysql start not start? But a manual likes sudo mysqld --datadir=/newlocation does? I have moved the data to new external harddrive formated as ext4. I updated my.cnf with the ...
0
votes
0answers
40 views

Load Balance Nginx, SSL, MySQL

So I need to load balance Nginx servers, can someone give me a good tutorial or explanation. With SSL is there such thing as load balancing SSL? I've heard of it. And clustering MySQL, how can I do ...
0
votes
2answers
87 views

Can I use iptables to forward vm guest requests to host

This is a bit complicated, but I have a Windows 7 vm (virtualbox) and I need create a persistent connection to the MySQL instance on my host machine. Binding... I can do this using mysql address ...
0
votes
0answers
11 views

MySql error in Edubuntu 12.04

As this the first time I m here to ask, as unable to run mysql on edubuntu 12.04 with following error. Kindly help in tracing the error.... thanks gnps@gnps-ibm:~$ mysql -u root -p Enter password: ...
1
vote
0answers
22 views

'tasksel install lamp-server' verses 'apt-get install lamp-server^' [duplicate]

Is there a reason why 'tasksel install lamp-server' or 'apt-get install lamp-server^' is better than another when setting up a fresh lamp server (or other group install)? Are they really any different ...
0
votes
1answer
67 views

while installing phpmyadmin getting dependency in ubuntu 12.04

i am newbie in ubuntu/linux system. i am trying to install phpmyadmin and i am getting following error. Some packages could not be installed. This may mean that you have requested an impossible ...
3
votes
3answers
682 views

How to deploy: ubuntu | apache | python | C++ | mysql [closed]

What if you want to make a non trivial web site and/or web service? How to deploy production server Apache with python for frontend and C++ for backend and MySQL for persistance? What glue should ...
0
votes
2answers
26 views

Where is my downloaded software

I have just downloaded and installed MySQL Server from download centre. It says it is installed but where is it? I have looked in all the usual places any help appreciated
1
vote
0answers
311 views

Problem connecting to database via SSH with MySQL Workbench

I am having trouble connecting to an external database via SSH with Workbench. The error that I get says: Could not acquire management access for administration UnboundLocalError: local variable ...
3
votes
1answer
139 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
35 views

Ubuntu Server 14.04 web server not gathering data from mysql server

First of all: I am a beginner, and have only basic knowledge about linux and servers. Also, this question is kind of vague, but i hope you can help. I would be very thankful for all kinds of feedback ...
0
votes
2answers
1k views

Problems installing mysql on Ubuntu 14.04

I hit the following error shortly on entering the mysql "root" password: An error occurred while setting the password for the MySQL administrative user. This may have happened because the account ...
0
votes
1answer
74 views

Mysql installation in Ubuntu [duplicate]

I had seen many answers to install MySQL. I had tried everything. It shows: There's no MySQL already installed Unable to locate package MySQL-server For synaptic, there's no keyword found Unable to ...
0
votes
1answer
26 views

Package list file lists the wrong version of MySQL [closed]

ubuntu-14.04.1-server-amd64.list in http://mirror.internode.on.net/pub/ubuntu/releases/14.04.1/ lists version 5.5.38 of MySQL server ...
1
vote
2answers
685 views

How to install MariaDB on Ubuntu 14.10?

After unsuccessful installation of the latest version of MariaDB through repository that is offered by official page (for Ubuntu 14.04) I've tried to install mariadb-5.5 which is already included in ...
0
votes
0answers
84 views

dependency issue while installing phpmyadmin on nginx webserver

I tried to find a solution for this problem for a long time but I cannot find it. Maybe you can help me. I have Ubuntu 14.04 installed on my system and want to use it for web development using nginx. ...
0
votes
0answers
52 views

Ubuntu php5-fpm www.conf pooling

Ubuntu VPS with 4GB RAM running wordpress with nginx, php5-fpm, and percona mysql 5.5 Daily unique visitors 8000 Maximum concurrent connections 90 For the above which is better www.conf (php5-fpm ...
0
votes
1answer
233 views

trouble in installing mysql workbench

i am trying to install mysqlworkbench in my ubuntu using sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1310-amd64.deb.3 but getting following errors (Reading database ... 188276 files and ...
0
votes
0answers
21 views

Problem with i7 notebook running ubuntu - Good hardware

I use ubuntu 14:04 on a notebook for web development. However, about 3 times a day it enters 'bottleneck'. The processing and memory usage go into space. Patiently when I'll see what is happening with ...
0
votes
2answers
141 views

How to install MySQL in Ubuntu Minimal 12.04

How can I install MySQL in Ubuntu Minimal 12.04? When I try to apt-get install mysql-server (as root) even after apt-get update and apt-get upgrade in a fresh install, I receive this: # Setting up ...
0
votes
0answers
127 views

Ubuntu Minimal 12.04 with MySQL installation errors (and minor issues, like the lack of Dialog and ReadLine)

I am trying to start my server with Ubuntu Minimal, because I will not use 90% of the default stack included in Ubuntu Server. But I can't install MySQL, getting erros like these: # Setting up ...
1
vote
0answers
164 views

Error 500 on localhost/phpmyadmin

I recently installed apache2 and phpmyadmin on localhost, and everytime I try to connect to localhost/phpmyadmin I get prompted with an "Enter your username/password". I enter root as the username and ...
0
votes
0answers
70 views

copy the MySQL Connector/J jar file to the domain-dir/lib directory

Where is the MySQL JDBC connector JAR supposed to go? To do this, copy the MySQL Connector/J jar file to the domain-dir/lib directory. For example, copy mysql-connector-java-5.1.30-bin.jar to ...
3
votes
0answers
687 views

MySQL Workbench GUI problems in Ubuntu 14.10

I've recently performed a clean install of Ubuntu 14.10. I got Apache, PHP and MySQL from Ubuntu's repositories, then installed MySQL Workbench (6.1.7) from the Ubuntu Software Center. It almost works ...
1
vote
0answers
202 views

Server slow after Nginx errors and restarting PHP

I have a server with Intel Xeon 2xE5520 2.27GHz, 48 GB Ram, 2x146 GB 15K HDD (Raid) OS Ubuntu 14.04.01, Nginx 1.6.2, PHP 5.5.9, MySQL. Webmin. My website is video portal. Traffic is approximately ...
0
votes
2answers
503 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
1answer
138 views

/usr/lib/i386-linux-gnu/libmysqlclient.so.18: no version information available

I wrote a program in C++ (QtCreator) on Ubuntu 14.04 LTS which reads values from Web-API's (curl) and stores them in a MySQL Database (using the MySQL C-API). When I start the program on my Desktiop ...
0
votes
0answers
98 views

Scheduled Cron Back up from EC2 to S3

I have created a script for scheduling sql back ups and store in Amazon S3. Below is the script that I used for taking backups. DATABASES="testdb" testdb_USER=root testdb_PW=root ...
0
votes
1answer
29 views

Why is mysql run in server-client model?

From http://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run Please make sure that you have installed the mysql-server, not the ...
0
votes
1answer
171 views

MySQL Workbench doesn't start

I installed MySQL Workbench from Ubuntu software center and it just doesn't start when I click on it. There's no error shown up. What's the matter? UPDATE: $ mysql-workbench --log-level=debug3 ...
0
votes
2answers
295 views

Installing LAMP - PHP not connecting with MySQL - Why?

Am followoing this amazingly simple LAMP tutorial http://ubuntuserverguide.com/2014/06/how-to-install-lamp-in-ubuntu-server-14-04-lts.html Installing Apache Installing MySQL Installing PHP The ...
0
votes
0answers
109 views

Mysql connection error

I'm newly installed Ubuntu 14.04 on my system. And I individually installed apache2, mysql 5.6.19 and PHP Version 5.5.9-1.whenever I connect to database it's giving error in the console window like ...
1
vote
1answer
58 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
vote
1answer
1k 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
82 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
45 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 ...
0
votes
1answer
131 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 ...
1
vote
1answer
90 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
184 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
89 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 ...
0
votes
1answer
207 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
285 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
101 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 ...