0
votes
0answers
15 views

Installing sql*plus on Ubuntu 14.04

I tried installing sql*plus on Ubuntu 14.04 by following 1, 2 and 3. But after downloading Instant Client I still facing following error; sqlplus: command not found I am new to Ubuntu, guide me to ...
-1
votes
0answers
16 views

How to change the domain name or IP address in mysql database in every tables [closed]

Iam Using openfire chat server in ubuntu which IP address 192.168.1.15, Now i want to move it to other ip 192.168.1.55 so i took the backup of my database. Database iam using is mysql so i took backup ...
0
votes
0answers
17 views

Insert the data in my XML file in a Database in Linux [duplicate]

My question is how to insert the data in my XML file in a Database in Linux.
0
votes
1answer
28 views

How to connect from MySQL to Web Application [duplicate]

I have been trying to setup a local instance for a web application. I am new to MySQL and I can't understand how to actually connect this database to the actual web application sitting in the ...
3
votes
2answers
208 views

How to make an executable file to update mysql database?

I have an Ubuntu server that is hosting my web application. But due to some security reasons it is not visible through Internet. The customer needs to update the database and update some values in ...
1
vote
1answer
83 views

Linux-Ubuntu Problem : Cannot find mysql database after connection is made to mysql

I have a war file deployed in webapps folder at /srv/apache-tomcat-7.0.53/webapps/ War name is InIndia.war I have deployed inindiadb.properties in classpath which is /srv/apache-tomcat-7.0.53/lib ...
2
votes
1answer
1k views

Remotely access mysql db on vm from windows as host [closed]

I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from the Host(windows) machine. Ubuntu is connected to the router via bridge. I can ping it ...
1
vote
0answers
187 views

What does this mysql error mean?

I'm on Xubuntu 13.10 64 bit. I know the password of my mysql database, but still can't login as root. I try to change the password sudo mysqld_safe --skip-grant-tables & I get [1] 8863 mypc ~: ...
0
votes
1answer
85 views

No reaction on service mysql start, init script works

After upgrading Ubuntu from 12.04 to 13.10, the MySQL server (now 5.5) does not start/stop with service mysql start|stop. When typing /etc/init.d/mysql start, everything works fine. Once it does ...
0
votes
0answers
56 views

MySQL moving DB problem

I am experiencing problems while trying to move my database files to another location. I've tried approaches described here but was unsuccessful. So, here are steps that I tried from the very ...
0
votes
0answers
69 views

mysql/c++ connector error

I have encountered the error for connecting mysql from c++ SQLException: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) I read some existing ...
2
votes
1answer
578 views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
0
votes
1answer
754 views

Automatically deleted MySQL database table when restart server

I installed LAMP server on my Ubuntu 12.04 Server PC. I changed the database storage location using my.cnf. After I changed the location it's working fine. But if I restart my MySQL database is ...
0
votes
1answer
1k views

12.04 - MySql won't start by using service mysql start

The only way I was able to get MySql to start was to issue: mysqld When I issued this command, it started rolling back some database transactions that were conflicted. I have tried issuing ...
1
vote
2answers
3k views

What alternatives to MS Access exist for database management on the Ubuntu platform (LibreOffice Base isn't cutting it) [duplicate]

I have a web-based MySQL database, which is very important. I have used the MySQL Connector to allow me to use an MS Access database to query, and clean up my database, through an ODBC connection. ...
1
vote
1answer
2k views

How to remotely backup a MySQL database?

How to backup MySQL database in a remote location using rsync? I tried mysqldump but it is storing the backup in the local machine only. Also I need the backup files to be stored in tar format in the ...
0
votes
3answers
379 views

GUI mysql tool for multiple databases

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to ...
0
votes
1answer
270 views

Bring in old databases in MySQL?

Ok, so when mysql updated a while back, it broke. It was simply not starting. So I tried fixing it, but hadn't been successful. I finally gave up, copied all the directories & files under ...
1
vote
2answers
183 views

Database create in mysql database

I am using Ubuntu 12.10 and recently I install XAMPP 1.8.1. My problem I can not create new database using both sql command and phpmyadmin. In phpmyadmin database creation input box is not shown and ...
1
vote
1answer
111 views

Create database

I want to create database. I know that I should use the following code: mysqladmin -h localhost -u {username} -p create lrs I don't know if something should be replaced with username located between ...
5
votes
5answers
34k views

How to connect and create a database in MySQL?

I want to install MySQL and create a database on it using the following code: sudo apt-get install mysql-server mysqladmin -h localhost -u {username} -p create lrs I get the following message after ...
3
votes
2answers
606 views

Is there a Linux equivalent to LinqPad?

I've recently been finding myself writing more SQL, on Windows with MSSQL and LinqPad and while I want to experiment on Ubuntu to get more of a handle on databases and I have no love lost for MSSQL, ...
1
vote
0answers
103 views

How do I edit the commands that start a service in Ubuntu 12?

So I am trying out GBrowse, as we will use this later on. But then, I'm getting this ------------------------------------------------------------------------------------------------ 256000 features ...
4
votes
1answer
3k views

Is it safe to delete preinstalled MySQL databases like INFORMATION_SCHEMA?

I just installed the LAMP server and PHPMyAdmin. Once I logged in I noticed databases already created and within them tons of tables and rows. My question of course is whether I can just delete them ...
2
votes
1answer
1k views

How do I copy MySQL databases to another Ubuntu machine?

I installed a LAMP server on my pc and created databases. Now I want to copy it to my friend's computer. How can I do this?
0
votes
1answer
2k views

MySql #2002 problem [duplicate]

Possible Duplicate: My MySQL installation is broken. How to completely reconfigure it? When i try to login in apache i get a #2002 error. When i try to login in MySQL via terminal it ask my ...
2
votes
1answer
193 views

Is it safe to Install Both Redis and MySQL on the same system?

Mine is a question not on how to install either but on whether I can have both MySQL and Redis-Server on my Ubuntu 12.04 machine. I need both for different projects, any help forthcoming will be ...
4
votes
1answer
380 views

Any good SQL shell programs?

I want to practice SQL commands on Ubuntu. I would just like to play with different commands and keywords. Where can I find something that helps? I don't want to install any server. I need a small ...
2
votes
2answers
3k views

Cant see databases of mysql from command prompt in ubuntu 12.04

1) I have installed mysql server and mysql client through apt-get install mysql-server and apt-get install mysql-client 2) when I run sudo netstat -tap | grep mysql, I see following: tcp 0 ...
1
vote
2answers
358 views

Why do the “iodbc” and “libmyodbc” packages conflict with each other? [closed]

When I install iodbc the libmyodbc package is removed, and I don't understand why. Does anyone have an explanation?
0
votes
1answer
409 views

How to access MySQL server with user password issued through LibreOffice Base frontend?

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password ...
3
votes
1answer
3k views

Can't install both libmyodbc and iODBC at the same time on Ubuntu 12.04?

I'm following this tutorial on Adding an ODBC driver to Ubuntu. I installed iODBC and then I went to install libmyodbc and noticed that it uninstalled iODBC, and now I can't follow the rest of the ...
1
vote
1answer
304 views

Failed to install Octave's database package on ubuntu [closed]

I'm trying to install octave's database package on my ubuntu machine. I had installed octave3.2-header before I installed the package, but some errors still exist. octave> pkg install ...
2
votes
2answers
75 views

Need database selection advise

I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design ...
4
votes
2answers
3k views

MySQL change datadir, problem with mysqld.sock

I tried to change the database directory, datadir, I did the following steps. My machine: Laptop Ubuntu 11.10 64-bit Install: sudo apt-get install mysql-server mysql-client All Ok, I can create ...
2
votes
1answer
1k views

MyODBC with MySql in Ubuntu 11.04

I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines: sudo apt-get install iodbc sudo apt-get install libmyodbc I start the ...
1
vote
1answer
1k views

How to install mysql DB while offline?

I have downloaded mysql-5.5.9-linux2.6-i686.tar.gz file. I don't know how to install it into my Ubuntu os. I don't have an internet connection, I'm posting here from browsing center. I can download ...
8
votes
1answer
3k views

Can I share MySql database files with Windows on dual boot?

I'd like to use in both Ubuntu and Windows (dual boot) my MySql database files residing on a NTFS partition. Will it work? Any gotchas?
0
votes
3answers
195 views

I want to install and get to building a personal MySQL DB

So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file? I've only had brief experience with MSAccess and OOo Base a long time ...
9
votes
2answers
6k views

Different locations for MySQL databases?

Can I configure MySQL to store a specific database in a separate place on disk? I still want any new databases to go to the default location, but there's a specific database that I'd like to have ...