Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
14 views

apache2,php and mysql - facing problem in editing the files and loading them in browser

friends, I have installed apache2 , php and mysql but now the problem is I don't know where to write the programs and put them back into the server folder so that I can access them back.My file i.e ...
-1
votes
0answers
11 views

Have localhost with dual boot (Windows/Ubuntu) share htdocs & mysql databases with XAMPP

I just got a new machine with dual boot Ubuntu+Windows 8.1 and set up a localhost using XAMPP in a way that allows me to edit and preview the files on both OSes (so htdocs and mysql databases have to ...
0
votes
0answers
7 views

HostGator to Amazon PHP send mail not working

After I transferred hosts from hostgator to aws ubuntu, all my send mail does not work. for example when someone register's, it is supposed to send an automated email to that user. I am using X-Mailer ...
0
votes
1answer
23 views

mysql-server hangs on setting password

Every time I try install mysql-server it hangs on this screen This is the case of not entering a password, but when I do enter a password it hangs on this screen after pressing OK I've been ...
0
votes
0answers
17 views

Ubuntu 14.04 problems with mysql

My problem is when I try to install mysql-server, I get some errors during the installation. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ...
0
votes
0answers
36 views

Installing Bacula while running MySQL 5.6

I am attempting to install Bacula (5.2.6+dfsg-9.1ubuntu3) on our server running Ubuntu 14.04 LTS. However, I am having troubles very early in the installation process. Running the command apt-get ...
-1
votes
0answers
13 views

My postfix/dovecot/mysql mail server can receave, but send mails only to me! [closed]

Please help! My (UBUNTU SERVER 14.04) postfix/dovecot/mysql can receives mails, but sends only to my own e-mail address! Here are parameters: myhostname = mycite.com alias_maps = hash:/etc/aliases ...
0
votes
1answer
78 views

MySql did not install properly and now I can not use the software center or remove MySql

When I open the software center I got an error saying "New software cannot be installed, because there is a problem with the software currently installed. Do you want to repair this problem now?" ...
2
votes
1answer
30 views

mysql-client-5.5 update error

I just run apt-get upgrade and many packets should be updated. I allowed them all (question after Disk Space and verification). After the download and my configured packages Ubuntu told me from an ...
0
votes
1answer
20 views

permission denied for mysql when compiling in CDT eclipse [closed]

I have a remote machine which I connected it by echoVNC and I access by vnc user & password. I installed eclipse CDT and I also installed mysql under the vnc user. I wrote a small program which ...
-1
votes
4answers
35 views

How to set up an environment for executing PHP files in Ubuntu 14.04?

I am coming from Windows.In Windows,i used WAMP and Adobe Dreamweaver CS 6. In Ubuntu, I am going to use Bluefish Editor. I need to setup LAMP(Linux Apache MYSQL PHP) and Phpmyadmin.Please give me ...
0
votes
2answers
39 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
14 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

including datas from my database in dropdown [closed]

I am creating a webpage in which person enters a name and the marketplaces registered under that name is displayed in a dropdown. Here's part of my code <form name="login" ...
0
votes
0answers
28 views

Port forwarding, trying get remote access to MySQL port 3306 [closed]

i've been trying to gain remote access to MySQL on a server. I am running into problems, i cannot seem to get the port forwarded, here are some of the steps i've made: i've told MySQL to listen to ...
0
votes
1answer
20 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
29 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
0answers
30 views

Can someone please explain this mysql statement to me [migrated]

I am trying to learn mysql on my own by debugging a php program. However I am now stuck. I do not understand what this particular statement is or what it does: $StatusRequirements = array( ...
0
votes
0answers
18 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
10 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
44 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
21 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
44 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
27 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
23 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
24 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
21 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
23 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
51 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
75 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
163 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
18 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
43 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
10 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
23 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
47 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
42 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
17 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
60 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
22 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
17 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
28 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
45 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
0answers
31 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
2answers
87 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
17 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
19 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
22 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 ...