MySQL :: Connecting To Db Using Terminal Utility UNIX / Mac OS?

Connecting Running On UNIX Server?
I'm a newbie to mysql. MySql server is running on UNIX server. My requirement is to connect this server from a .NET application running on Windows platform.

Here is my code

string connectionString = "Server=10.2.10.96;Port=3306;
Database=wlpmidwest;Uid=wlpmidwest;Pwd=wlpmidwest1;";
try
{
MySqlConnection myConn = new MySqlConnection(connectionString);
if (myConn.State == ConnectionState.Closed)
myConn.Open();
MySqlCommand myCommand = new MySqlCommand("select * from tblUno", myConn);
MySqlDataAdapter myDA = new MySqlDataAdapter(myCommand);
DataSet myDS = new DataSet();
myDA.Fill(myDS, "dsUno");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}

When i run this code i'm getting Exception as "Access denied for user 'wlpmidwest'@'10.16.131.123' (using password: YES)".

What details i need to do in Server and Client side to make this code work.

Posted: July 06, 2010 02:05AM

View 2 Replies! View Related

Dbdiff Utility
Does anyone have or know of a utility that will generate SQL to upgrade one
MySQL database to look like another?

For example 'dbdiff db1 db2' generates the SQL statements that can be
applied to db1 to look just like db2.

Any suggestions short of comparing the database schemas line by line?

Posted: July 19th, 2005 11:39 PM

View 4 Replies! View Related

A Decent Utility
I have tried multiple utilities to backup and restore mysql databases... I say large in my header but they are not really. They are just to big to restore with phpMyAdmin.

I can't tell you how frustrating it always is when I try to do this... there will always be some kind of error when I try to do it. I have tried various utilties and nothing seems to do the job properly. You know those days when everything you try fails?

Yes I know I can break them up but surely there must be something that can do this for me on the fly reliably?

Posted: November 24th, 2005, 05:49 AM

View 7 Replies! View Related

Mysqldump Utility
We have taken the Backup of MySQl database with version
mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686) Using mysqldump utility.

We tried to Restore the Same in another Linux System with mysql version mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i686) using readline 5.0 using the same mysqldump utily

It is giving Version mismatch error and unable to restore the Database. We also used --compatible=mysql40 Option but No change

Posted: January 17th, 2007, 12:31 AM

View 2 Replies! View Related

Utility To Display Relationships
Does anyone know of a utility that will create a visual representation of my db?
Access has a feature that kinda helps with this

Posted: April 19th, 2005, 11:04 AM

View 6 Replies! View Related

Utility To Track Changes To Database?
Does anyone know of a utility a newbie could use to track changes to a MYSQL database? I have admin priv and run my own LAMP server. Similarly, there is a utility I use that will track changes to a windows registry after an application is installed. Then it gives you a difference of the two - the previous registry values followed by the changes (additions, deletions, and modifications). I was looking for the same thing for MYSQL. I have a php program that runs and need to figure out exactly which MYSQL tables are modified and in what ways.

[root@mr1 ~]# mysql --version
mysql Ver 14.12 Distrib 5.0.51a, for pc-linux-gnu (i686) using EditLine wrapper

Posted: September 25, 2009 06:42AM

View 2 Replies! View Related

Utility To Create An ERD From An Already Existing DB?
I have my database built already, but I really want to print out an erd to reference while I'm building my models. Is there a utility that can generate an erd from a SQL dump or by connecting to the database directly?

Posted: Jul 2 10 at 22:33

View 2 Replies! View Related

Graphical Backup Utility For Mysql
I am currently reviewing our backup procedures. Part of the issue has been
finding the right fit. There are obviously backup products that provide
mysql agents but unfortunately can not for fill our complete backup/disaster
requirements. I have evaluated bakbone, arkeia, brightstor, veritas. I am
currently looking at evault, commvault and ipstor.

I am now looking to separate mysql from the rest of the backup. I am
looking to use a standalone graphical (web interface) utility that can
schedule full and transaction backups on a hourly basis and save the
resulting files to a shared drive (either Direct or NAS). It would be nice
to have easy control to restore data to a table level or roll forward/back
through transactions.

Posted: July 19th, 2005 11:49 PM

View 3 Replies! View Related

Utility To Convert Between MySQL Versions?
My webhost downgraded from mysql 5 to 4 and I'm seeing errors in the forum I was running. All I can see that would have changed and given me this database error would have been this downgrade. Is there a conversion utility availaible that can change back and forth between MySQL versions? I've looked around for about an hour thru Google and on this forum, but I haven't found anything yet.

I was getting password errors, but we seem to have resolved that issue, and now I'm left with this database connection error.

Thanks for any assistance!

P.S. The errors I get are:

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Posted: August 18, 2006 05:52PM

View 4 Replies! View Related

Java - What Is The Application/utility Of Foreign Key In Db
Allow my to elaborate on the question with an example. I am writing from the perspective that

(1) bytecodes should not be used to implement the logic already implemented (hopefully more efficiently) in the database engine (e.g., if we need to filter out 20 lines out of 500 coming out as the result of an SQL query, we should be writing a better where clause), and that

(2) I have only a conceptual understanding of foreign keys (e.g., they automatically create, manage and enforce the constraints required to maintain data integrity across different tables).

Now, lets consider a simple schema with 4 tables and 15 columns in them as follows (assume all columns are not null):

people
pid bigint autoinc PK
fname varchar(32)
lname varchar(32)
dob date.............

Posted: Jan 23 at 6:12

View 1 Replies! View Related

Load Utility :: Have To Add An Extra Comma After Last Field
When using the load utility on a CSV file, it seems I always need to edit the input file and add an extra comma after the last field in order for MySql to parse the line properly.

I use a command like:

LOAD DATA INFILE 'absolute path to file.csv'
IGNORE
INTO TABLE table-name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED
BY '
' ;

for an input file created on a Linux system and I always have to add the extra comma to the end of each record in order to get the records loaded correctly.

Does anyone have some experience with this and can provide some suggestion?

Also, is it possible to use the mative MySql load utility to load a fixed-format input file? From everything I am reading it seems you have to use some other language like perl or python or php, etc in order to load a fixed-format file.

Posted: July 20th, 2005 12:22 AM

View 2 Replies! View Related

Mysql Command Line Utility Help Facility
I have installed MySQL 5.0.18-nt on my Windows XP PC. So far everything looks good.
One slight question about the command line utility; everytime I use the help command it does not find anything. Even "help contents" doe snot find anything. Is there something I can download and install so that the "help" command will be able to find the data for which I am searching.

Posted: January 12, 2006 10:30AM

View 1 Replies! View Related

Utility - Offline Table Definition Generator
I'm looking for something similar to the table creation form from phpmyadmin, but it should simply display a CREATE TABLE statement in a textarea below the form. It should also not require MySQL, PHP, or even a server to work. I want this for times I'm working on projects and just want to whip up a quick table definition. I'll more than likely always have a text editor open, so being able to save to file isn't a must-have. I'm on Ubuntu and use Gnome. A tiny GTK application I could stick in my Applications menu would be ideal.

Posted: Jul 2 09 at 9:04

View 1 Replies! View Related

Terminal Bell
Does anyone have an idea how to disable to very, very loud terminal bell on windows XP when using MySQL? Everytime I enter a typo in a command or whatever, my eardrums are about to break because of the redicilously loud terminal bell.
It's a minor issue, but I wuold still like to keep my hearing abilities as they are...
Muting the XP doesn't seem to have any affect on this terminal bell.

Posted: June 07, 2006 04:39AM

View 1 Replies! View Related

Connect To Db From PHP Via Terminal?
I'm trying to connect to my localhost MySQL server via php in the terminal. It's outputting that it cannot connect to the host through my socket. My PHP ini install says this

MYSQL_SOCKET /tmp/mysql.sock

so i used

mysql_connect("/tmp/mysql.sock","root","","");

And i get errors

Posted: Sep 30 09 at 9:49

View 1 Replies! View Related

Optimization On Nested Query: Utility Bill Analysis?
Relatively small queries (a few thousand records) are beginning to push 1000 ms, and I'm fairly certain that there are some simple things that will speed things up.

Several factors complicate the problem:

* Bills are pseudo-monthly -- they don't fall on month boundaries

* Usage needs to be normalized to daily values, i.e. divided by the number of days spanned by the utility bill

* Properties can have multiple services, e.g. two electric meters, which need to be summed on days when they overlap.

But first, the tables.Everything hangs off the metered_usage table (a "fact" table in the dimensional database lingo), which references "dimension" tables -- these describe the type of service, attributes of the property, and the start and end dates of the bill.

> describe metered_usages;
+--------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| start_time_id | int(11) | YES | | NULL | |
| end_time_id | int(11) | YES | | NULL | |
| service_address_id | int(11) | YES | | NULL | |
| metered_service_id | int(11) | YES | | NULL | |
| quantity | decimal(13,3) | YES | | NULL | |
| cost | decimal(13,3) | YES | | NULL | |
+--------------------+---------------+------+-----+---------+----------------+

[code]....

Posted: April 22, 2010 10:16PM

View 2 Replies! View Related

Windows Terminal Service
Can anyone tell me what command i need to write inorder to do a mysqldump of a particluar database?
I'm currently running a dedicated server. I am accessing mysql.exe from within Windows Terminal Service so i need to know how to write the mysqldump from here.

Posted: January 31st, 2005, 08:00 AM

View 2 Replies! View Related

Cannot Run MYSQL Within Konsole Terminal
I have installed MYSQL using the urpmi commands within Mandriva.

I am now trying to get this to work but when I type in mysql in the terminal I get the following error.

[root@localhost ginge]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Have I missed out any packages? I installed the following...

Packages apache-mod_auth_mysql-3.0.0-17mdv2009.0.i586, apache-mod_auth_mysql-3.0.0-17mdv2009.0.i586 are already installed
Packages mysql-administrator-5.0-1.r12.5mdv2009.0.i586, mysql-administrator-5.0-1.r12.5mdv2009.0.i586 are already installed

Posted: February 20, 2009 04:16AM

View 2 Replies! View Related

Terminal Problem Using MAMP
Ive set mamp up on my mac and although i know i can use phpamin to manipulate mysql i want to use the terminal to do it.

so i cant even get myself dumped on the mysql command line. I cant seem to find the path to mysql. I think the right path is to the folder which contains mysql and mysql admin...but im not sure.

In order to get to this folder i type this::

cd /applications/MAMP/Library/bin;

This works but i dont know what to type next so i can get in to mysql and inout the default user name and password using this:

-u root -p.

Posted: Nov 19, 2006, 11:17

View 4 Replies! View Related

Connect To MYSQL From PHP Via Terminal
trying to connect to my localhost MySQL server via php in the s outputting that it cannot connect to the host through my socket. My PHP ini install says this

MYSQL_SOCKET /tmp/mysql.sock
connect("/tmp/mysql.sock","

Posted: Oct 17 10 at 0:18

View 2 Replies! View Related

How To Specify The Terminal Width In Mysql CLI
I'm using the mysql CLI, however the result displays always wraps around on my terminal screen. is there any way to specify to mysql the size of my terminal screen?

Posted: Oct 8 09 at 23:07

View 2 Replies! View Related

Cancel An Entry In Terminal?
Currently reading the book "Build your own database driven Web site." It's been great so far. I'm trying to enter a bunch of jokes into the database. That's not a problem. The problem comes when I make a mistake and don't notice it until I am getting ready to hit enter at the end. From the book, it says to hit "c" and enter to clear the entry. That does not work. I just get a new "'>" terminal entry. If I try to enter the code, it will not work.

How do I get back to "mysql>" if I make a mistake? I've included a screen shot of what I'm talking about. I needed to go back to the first line to change "I'm" to "I'm".

Posted: Nov 15, 2010, 13:49

View 7 Replies! View Related

Connecting To Db Using Terminal Utility UNIX / Mac OS?

how can I connect to MySql database located for example on www.myfakedomain.com with terminal utility?