Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
53 views

How to insert data from text to mysql? [closed]

I get this text from router via ssh. But I want to insert user(fr-XXX) and macadress(F0:24:75:33:22:11) to mysql routerusers table. Flags: M - mac-cookie # USER DOMAIN ...
0
votes
0answers
22 views

remove mysql with its unmet dependencies from ubuntu

I tried to install mysql into ubuntu The installation file was .deb It was not properly installed. Now i want to remove it. I used following command to remove it sudo apt-get remove --purge ...
0
votes
1answer
23 views

How can I stop another working webserver?

I get this error when I try to start Apache web server. I've been working on it for about a month and suddenly this error appeared today: error:: xampp: another webserver is already running. any ...
1
vote
1answer
66 views

MySql 5.6 crashing on Ubuntu 15.04 arm64

I installed mysql using the command sudo apt-get install mysql-server At the end of the installation it throws error saying "Unable to set Root password". I tried googling and reading other ...
0
votes
1answer
42 views

how to access mysql in console

I installed mysql alone with xampp and runing all services successfully, but when i try to login to mysql server using mysql-client it gives the following error. user@user-pc:~$ sudo /opt/lampp/lampp ...
0
votes
0answers
16 views

Why use Amazon's AWS RDS instance for mysql instead of just manually creating mysql?

I was playing around with Amazon AWS and at this point just not sure what are the benefits of creating an RDS instance for lets say mysql database instead of simply login in into the server and ...
1
vote
1answer
70 views

Wrong permissions on configuration file of phpmyadmin

I have installed xampp on Ubuntu 15.04 and after starting the server, I get: phpMyAdmin - Error Wrong permissions on configuration file, should not be world writable! How should I proceed?
0
votes
0answers
49 views

NGINX Auth support and MYSQL

I have installed NGINX server. The requirement is to allow only certain IP addresses to access this service. The list of allowed IP are stored in a MYSQL database. I was able to install and configure ...
1
vote
3answers
60 views

Mysql didn't startup after rebooting

After I rebooted my server, everything started up normally except for "mysql", i tried to start it up manually "/etc/init.d/mysql restart" or with "service mysql restart", it fails In log file it ...
0
votes
0answers
47 views

MySQL remote access doesn't work when there isn't internet connection in router

I'm using Ubuntu Server 14.04, and installed MySQL 5.6 to be accessed remotely on my LAN. Everything is working perfectly, except when I lose my router internet connection. My ISP goes down often, so ...
0
votes
0answers
36 views

Service Mysql status not working correctly

I did follow this to reinstall my mysql server. http://stackoverflow.com/questions/25244606/completely-remove-mysql-ubuntu-14-04-lts when I add mysql to my autostart update-rc.d mysql defaults and ...
0
votes
0answers
18 views

Mysql DB Location and users [duplicate]

I can't figure out where the Mysql databases and Users is located in Ubuntu 14.04 my scenario is that i want to move the DB and users from 10.0.2.2 to 10.0.2.21 with rsync but obliviously i need to ...
0
votes
1answer
33 views

MySQL requires restart in Terminal every time laptop is restarted. 14.04.2 LTS

I installed MySQL a few weeks ago. The problem now is that every time my laptop is restarted I also have to manually restart MySQL in terminal via: sudo service mysql restart The errors I get ...
0
votes
1answer
38 views

How can I fix phpMyAdmin, broken after Ubuntu update?

I updated Ubuntu from 14.04 to 15.04 and during the update process it asked for my dba password so it could update phpMyAdmin, however it kept refusing it. Possibly due to it saying it was trying ...
0
votes
0answers
36 views

Difference between using mysql in xampp and using mysql seperately

I have used xampp on windows to do some php programming(basic) and now i'm trying to do some python/perl database connectivity programs(again basic) with mysql. The thing is when i used xampp, it ...
0
votes
0answers
64 views

Mysql not installing on server and throwing error after root user password entry

I currently have a server on Digital Ocean running their standard Rails application (Nginx, Unicorn, Postgres, Ubuntu 14.04). When I try installing mysql with apt-get install mysql-server It seems to ...
0
votes
0answers
233 views

SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) ubuntu

I installed magento and mysql on AWS. when I am trying to change the root password of mysql then it is working fine in phpmyadmin panel but magento giving error. I have checked local.xml file in ...
2
votes
2answers
175 views

where to see created mysql database and tables

There is no mysql in /var/lib where I expected to find the databases and tables.
1
vote
0answers
30 views

The connection has timed out when trying to access mediawiki page. Cant figure out why its not working

For some reason, I cannot access the mediawiki website I created, it says "The connection has timed out" whenever I try to access the main page.I started randomly about a week ago, and I cannot find ...
0
votes
0answers
112 views

Keystone Identity service: Unable to establish connection

Can someone please help. I've been stuck on this for quite some time now and its frustrating me alot. I cant move forward. keystone tenant-create --name admin --description "Admin Tenant" Unable to ...
0
votes
0answers
27 views

importing mysql backup into a mariaDB instance on ubuntu 14.04

I just installed mariaDB on an ubuntu box using the command: sudo apt-get install mariadb-server per the documentation found here: How to install MariaDB? I have a .sql file that was created on ...
0
votes
0answers
56 views

Ubuntu 15.04 Mysql Error

I tried to install mysql-server into my Ubuntu server sudo apt-get install mysql-server and I also installed phpmyadmin however it didn't work, when I typed the word mysql either with or without ...
0
votes
1answer
61 views

Mysql installation error on ubuntu 14.04 [duplicate]

When i try to install mysql by this command on ubuntu 14.04 i get this error. Help me with simple and detailed solution as I am new on ubuntu. sudo apt-get install mysql-server Error: Reading ...
0
votes
0answers
60 views

MySQL 5.6 does not restart at boot time on Ubuntu Server 14.04.2 LTS

I have installed MySQL 5.6 client/server and libraries on Ubuntu Server 14.04.2 LTS with apt-get. MySQL is set to start by itself at boot time but it does not (done with sysv-rc-conf Default-Start: 2 ...
0
votes
3answers
19 views

having problem installing libmysqlc++-dev

aanchal@aanchal-Inspiron-3542:~$ sudo apt-get install libmysqlc++-dev Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
1
vote
2answers
87 views

Need to install specific version of LAMP prerequisites on Ubuntu 14.04 desktop LTS

I need to install below specific version on Ubuntu Linux (desktop 64-bit 14.04 LTS) how can I do that please help PHP 5.3.28 Mysql 5.5.38 Apache 2.2.26 Any help will be highly appreciable Regards ...
2
votes
1answer
24 views

What is a (reasonably) secure and automated way to backup my mysql database using (any) free cloud/online services?

I have a mysql database that I use for personal devlopment. I would like to back-it up online using any free (in cost) online storage. (dropbox, google-drive etc...) I am assuming a shell script ...
0
votes
0answers
24 views

MySql Workbench on Ubuntu 14.04 Create Table editor not working

My system: Dell Inspiron 5000 laptop Ubuntu 14.04 LTS 64 bit OS I installed MySql Workbench 6.0. If I attempt to create a new table using the GUI, the table editor opens and suggests a first column. ...
0
votes
4answers
30 views

I installed mysql sever. but it doesnt work.?

ERROR 1045 (28000): Access denied for user 'vindhya'@'localhost' (using password: NO) this is the error massage I got... i don.t know how to log mysql
0
votes
1answer
79 views

MySQL Crontab Check

I have a serverpilot.io server running from digitalocean (1gb Ram), MySQL will crash once a week, the stats say the server is using ~256 mb out of 1 gb, but mysql will crash saying out of memory.... ...
0
votes
1answer
51 views

Does someone knows how to fix this installation bug in ubuntu?mysql-server-5.6 E: Sub-process /usr/bin/dpkg returned an error code (1)

I'm trying to remove mysql-workbench. But everytime when I try to remove something related with mysql, I get this error. Reading package lists... Done Building dependency tree Reading state ...
0
votes
1answer
39 views

Backup of MySQL database manuelly

in the datadir of mysql are the folders named like the database. If I want to install this database on an other server manuelly, could I copy this folder on a e.g. USB stick and put it on the datadir ...
0
votes
3answers
157 views

Having trouble in installing and removing mysql in ubuntu

I have trouble in installing or removing the partly installed mysql-server-5.6 in ubuntu15.04. The error I am getting was sudo apt-get -f install Reading package lists... Done Building dependency ...
0
votes
0answers
25 views

Loadbalancing mysql with haproxy

How to load balance a mysql server with master-slave architecture with HAproxy?If not ha proxy,is there any other way?
0
votes
1answer
22 views

How to create folder in mysql5.7?

I try to upload video php to mysql. i try to create folder but not success. below step i apply Edited phpmyadmin's config file nano /etc/phpmyadmin/config.inc.php Added the path for both upload and ...
0
votes
1answer
24 views

Problems with making a lamp database in ubuntu

I'm trying to create a lamp-server database. When I go to localhost in my browser the default apache "It's working" page is displayed. But when I'm trying to see my database with localhost/posts I get ...
1
vote
2answers
50 views

What do these numbers mean in syslog?

I'm trying to determine why MySQL server process is being killed due to out of memory, so am looking at the sylog. Immediately before the 'out of memory' I see lots of lines with differing numbers but ...
0
votes
1answer
89 views

Can't connect to local MySQL server through socket error - Reasons of this failure?

This is my first post here. I am a newbie in Ubuntu servers :) I've a WordPress multi-site running on Ubuntu 14.04.2 LTS server, and about once per month all the sites are down due to some MySQL ...
1
vote
2answers
412 views

Cannot install mysql server 5.5 on ubuntu 14.04

I have tried many ways to install mysql-server. I first tried installing by executing sudo apt-get install mysql-client-5.5 mysql-server mysql-server-core-5.5 I was asked for root password, and ...
-1
votes
2answers
68 views

how to reconfigure phpmyadmin?

Error: "http://localhost/phpmyadmin/index.php" Cannot connect: invalid settings. Connection for controluser as defined in your configuration failed. I was using lampp with mysql password as root ...
0
votes
1answer
78 views

mySql not working after upgrading to 15.04

After upgrading from 14.10 to 15.04 when i start rails server it gives this error: arslion@arslion-Lenovo-B570e:~$ rails s ...
0
votes
1answer
251 views

E: Unable to locate package libmysql-ruby

I try to install mysql for rails but i know that first must install the package libmysql-ruby I do the command E: Unable to locate package libmysql-ruby But It returns Reading package lists... ...
0
votes
1answer
20 views

Uninstall MySQL completely

The answers to related questions forget to: remove the MySQL databases remove the mysql user remove the logs in /var/log How do I uninstall MySQL completely?
0
votes
0answers
28 views

How can I solve problem with Jomla installation on EC-2 server?

My name is Igor, I woold like to install joomla on Amazon EC-2 Ubuntu server free tier, but I could not do this. After a week of probe and tests I deside to write you. This letter I send to Amazon and ...
0
votes
1answer
57 views

Error establishing a database connection several times a week

I have a client I do web development for who had a basic low traffic WordpRess site running on Ubuntu 12.0.4 with Digitalocean. Basic LAMP stack that they provide pre built with WordPress installed. ...
0
votes
2answers
47 views

Redundant Web Server

I have an ubuntu 14.04 server that we use as our web server (apache). We have a public web site that is built on Drupal, uses a MySQL DB and we also have some files that are uploaded to our site and ...
0
votes
0answers
22 views

problem removing mysql

I am getting this error: E:Sub-process /usr/bin/dpkg returned an error code (1) At the end when i try uninstalling mysql using the command: sudo apt-get remove –purge mysql-server mysql-client ...
0
votes
0answers
15 views

Need to configure backup webserver

I configure ubuntu web server with apache and its run php application with mysql database. now i need to config another server. because master server down another server must be provide application. ...
0
votes
2answers
42 views

How to allow lamp and apache2 service run parallel?

I have a php project in var/www/html. It runs when I start apache2 service is started. But I cannot access phpmyadmin where I have a database that is being used in my php project. (I had to stop lampp ...
0
votes
0answers
32 views

php files connected with mysql server not working

I started a php project in netbeans and connected it with a database in localhost/phpmyadmin. But on running it gives this error on browser.. Why does this happen? How to avoid it? Here are the ...