Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MYSQL


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





GUI Interface For Unix Linux And Solaris Etc.


Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc)

There was an earlier thread about it -
http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI

but most of these seem to run on Windows only.




View Complete Forum Thread with Replies

Related Forum Messages:
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux?
I'm trying add a user account and password to the db server but I'm not
having any luck from the command prompt.I'm trying to setup the nexus
discussion software.

View Replies !
Linux Mysql Nfs : Bind On Unix Socket: Function Not Implemented
I have installed Mysql on red hat ES release 3 and i was working great.

For my applications, I decided to to put the data directory on another machine. The other machine is a big disk of storage (Adaptec snap server 1 terabyte)
It working great for all applications except Mysql

In fact, i put /var/lib/mysql on another machine and I made a nfs mount

When i try to start mysql i have this :

/etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

in the error message i have this

051028 11:12:33 mysqld started
051028 11:12:33 Can't start server : Bind on unix socket: Function not implemented
051028 11:12:33 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
051028 11:12:33 Aborting

051028 11:12:33 /usr/libexec/mysqld: Shutdown Complete

051028 11:12:33 mysqld ended

I have verified the permission and everything seems to be ok....

View Replies !
Solaris 2.6
We are using a really old version of Solaris 2.6. Mysql.com site does
not seem to have mysql binaries for this version of Solaris. The
earliest version they have is for Solaris 8, which I believe is same
as Solaris 2.8.
Is there a place where we can download mysql 4.x for Solaris 2.6 or we
have to upgrade Solaris.

View Replies !
Mysql 5.0.22 Install On Solaris 10
I'm trying to do an install of mysql on a Sun Ultra 10 machine running
Solaris 10 (1/06) which is a completely clean, fresh install.
I can get the packaged (with Solaris 10) version of mysql (4.0.something)
running easily.
I do have version 5.0.15-standard installed and running on another machine.

It appears that between 5.0.15 and 5.0.22 someone has made a decision to
change the locations that the files are sent to and nobody has updated
anything (that I can find) in the documentation.
If I'm not mistaken, 5.0.15 gets installed in /usr/local/mysql but 5.0.22
goes into /opt/mysql/mysql

I am installing the package from the Solaris binary .pkg format which is
what I prefer - I'm not into compiling programs from source. This is also a
test platform that has a clean disk so that I can test this before I try and
touch anything else.

View Replies !
About Java Driver In Solaris 10
I am planning to take admission to MCA and also planning to do my project using Solaris platform can anyone tell me how to configure MySql on Solaris as well as how to use database connectivity with java i have downloaded connector for java but its not working.

View Replies !
Php/mysql Connector For Solaris
I recently installed mysql 5 standard package for solaris on a solaris 9 machine. I also have an apache2/php5 installed and operating on a solaris 9 machine. I'm trying to connect to mysql server via php. I already granted the apache2/php5 server permission to access the database, but I'm still getting denied (Could not connect: Host 'apache2php5_server' is not allowed to connect to this MySQL server). Do I need to install some module in order to accomplish my task? Is there a php/mysql connector I need to install? If so, is there a solaris version?

View Replies !
Building MySQL On SPARC Solaris 9
I have been trying to compile MySQL 4.0.15a on a Sparc Solaris 9 machine
without any success. I do not know if the reason of my failure is the fact
that I want to include SSL support on my MySQL binary. I have successfully
installed (at least that's what I think) OpenSSL on my machine, but have
reached a point where I do not know what else to do. Code:

View Replies !
Compiling MySQL 4.1.5-gamma In Solaris 8
I'm trying to compile the latest mysql source in a Sun box:

# uname -a
SunOS bucktown 5.8 Generic_108528-20 sun4u sparc SUNW,Ultra-80

My configration looks like this:
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure
--prefix=/my/path/app/mysql-4.1-gama
-with-unix-socket-path=/my/path/mysql-4.1-gama/socket/mysql.sock
--with-mysqld-ldflags=-all-static
--with-charset=utf8 --with-collation=utf8_general_ci


First I tried with the make that comes with solaris then I tried with
the latest GNU make . In both cases the process seemed to be running
ok a while, but then I got this error:

ld: fatal: File processing errors. No output written to
mysql_tzinfo_to_sql
collect2: ld returned 1 exit status
make[4]: *** [mysql_tzinfo_to_sql] Error 1
make[3]: *** [all-recursive] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2

View Replies !
MYSQL Fulltext Search On Solaris Server
I want to know on Solaris how I could lower the the minimum fulltext
search string from 4 to 3.

Right now using the FullText search any
string less than 4 chars is ignored. I'm sure there's a link explaining
how. Maybe UNIX help in general on his would be good as well.

View Replies !
Solaris 8 Daemon Fails Because Unknown Option?
I guess people did not see my post from the install thread... I am really really stuck now! Does anyone work on Solaris???

Whatever option I use to start the daemon I get this:

050310 15:27:35 mysqld started
050310 15:27:35 [ERROR] /opt/mysql/bin/mysqld: unknown option '--~'

Please Help

Note that I am using the binaries from this site.

View Replies !
Compiler Used To Successfully Compile Mysql On Solaris 8 Machine
I have been trying to compile mysql on a solaris 8 machine. However, I
am getting internal compiler errors. What compiler and version did anyone
use to successfully compile mysql on a solaris machine.

View Replies !
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ).

But,

1. I want know XA Interface in C API. ( using xa_switch_t like other DB
( oracle, infomix, .. ) )I can't find this in Manual.
2. If MySql is not support this, does Mysql have the plan?

View Replies !
XML Interface
Does anyone know of any project that would provide an XML interface to a database? I would like to create an XML document describing what I want to do, send it to a server and get some XML results back.

Has anyone heard of anything like this?

View Replies !
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right?

If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is:

Is there an open source application that applies a user interface to a MySQL database so a user can do these things?

View Replies !
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access ..
not even like apart from phpmyadmin but like windows
on which we can make database , tables , reocords .... etc ..
i guess micro olap have this .. but its not free ..

View Replies !
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.

View Replies !
End User Interface
My goal is to set up a database
to track our inspection data at our company. Currently, we are using
Excel spreadsheets to make inspection reports. I would like to be able
to get this information into a database so that a technician can set up
the inspection plan before the inspector gets the part (the inspection
plan would include the Customer Name, Part No., Revision, Items to
inspect, etc.) Then when the inspector receives the part, they can pull
up the inspection plan and enter the dimensional values obtained for
each attribute on say six or ten parts and print an inspection report.
Then this data can be sorted and viewed in different ways.

We have three Windows 95 computers and three Windows 98 computers we
are currently using on an ethernet network.

I am thinking of using MySql, Apache and PHP to set this up.

Would there be a simpler way to create an end user interface to MySql
other than
using PHP and Apache?

View Replies !
Switchboard With GUI Interface
If I wanted to create a switchboard would I be able to use the GUI Interface to do so? I am in the process of learning MYSQL.

View Replies !
Specify Interface At Bind-address
Is it possible to bind MySQL 4.1 to more than 1 interface? Will
multiple 'bind-address=x.x.x.x' statements do the job?

View Replies !
MS-Windows Front End Interface
Is there an MS-Windows front end interface for mySQL ? I'm thinking
of an MS-Access sort of approach for basic database configuration
and maintenance. Maybe there's a back door way to ODBC myself from
MS-access to mysql on a Windows system ? Does Mysql have an ODBC
front end I can get in through ? Any pointers to some directions ?
I plan to use perl/my-sql for web work. But, it seems like a _lot_
of work to build the databases and populate them via mysql commands.
I'd like to be able to work them _locally_ through a basic data
maintenance program and then move it to the (web) server when ready.

View Replies !
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the
content of the table. If I ran a query, such as select * from table,
it would scroll out the result. Now, with the newer version, all it
does is hang. Is there some setting I'm missing that needs to be
changed? This was newly installed on our apple server.

View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and
Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't
need to manage anything. I just need the data. What kind of interface can I
use to query and save data locally? I don't see any MySQL drivers available
when I try to setup an ODBC from my desktop. Can I download one somewhere?

View Replies !
MySQL Interface Required
I hope this question is appropriate for this group.

My server provides a MySQL database. Do I need a third-party interface to
add tables and records to it, or is their another way?

View Replies !
Interperted Language To Interface
my question is, what is the best interperted language to interface with MySQL? i was told Perl by some and Python by others. the reason i am looking is because i wanted to create a custom gui and atmysqlt to make it easy to add entries or pull up certain records from the database.

View Replies !
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word.

I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?

View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?

View Replies !
Database And Client Interface
I am planning to use MySql for my building my database.

I already installed MySQL on my system. I would like to know have two databases.
1. for developement
2. for storing the correct data from the development database.

Can i have two databases on the same server, so that I can copy data from one database to another.

Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program.

What drivers or connections do I need to download in order to talk to the database from Matlab.

View Replies !
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.

View Replies !
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.

View Replies !
Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db.

Example: I have a table with {id, url, desc}
The program must generate a page with text fields to enter this information.

View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets).

What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing.

What I have found on the net so far is:
Control Center
Front
SQLyog
NAvicat

Any feedback on these? Ease of use and reporting are most important attributes.

View Replies !
Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...).

Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).

View Replies !
Using C Interface To Access SQL Data On A Website
Is it possible to use the C interface to access data held on a mySQL server, preferably without needing to use anything like IIS.

View Replies !
Configure Database To Work With An Ms Access Interface
How do I configure the MySQL Database to work with an ms Access interface.

View Replies !
Graphical Interface Hangs When I Try To View Conents Of Table
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.

View Replies !
Migrating Data From MySql(Windows) To Mysql (Solaris)
I am running mySql 5.0 on windows and i plan to migrate to Solaris, i have install the MySql 5 on solaris 10. Please how do i transfer all my Data, and i was wondering if there is a Data File That includes all my data that i can just copy over to the new system.

View Replies !
Using TCP/IP Instead Of Unix Sockets
An associate has asked me to take a look a problem he's having with starting
mysql. I thought I'd give it a shot to learn some more about mySQL before
having him turn it over to someone more knowledgeable than I. But I have to
ask here first.

Attempting to connect to the database via mysqladmin or mysql results in the
error (paraphrased) "Cannot connect to local database using socket
"/var/lib/mysql/mysql.sock".

That is the path to the socked specifiet in both mysqld and client sections
of the my.cnf.

mysqladmin -h `hostname` version shows that the Connection is via TCP/IP
rather than Unix Sockets.

Running on Redhat Linux AE 3 (I think)

/var/lib/mysql is world-writable-readable, but it is not owned by user mysql
(my next attempt to fix this)

/var/lib/mysql/mysql.sock is 777.

My question: What would be causing mysqld to be using TCP rather than Unix
sockets? I've checked permissions, verified settings in my.cnf (which is
very sparse... other entries are for logging), confirmed mysqld is running
and accessible via TCP/IP.

View Replies !
UNIX Timestamp
How do I get a UNIX timestamp in MySQL?

View Replies !
Unix Date Problems
1) I was investigating the unix_timestamp routine in mysql (version
3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned
with a value of -3600. Then, as you can see, it suddenly corrected
itself. I can't replicate this error, but it caused me to shudder.
Attached is the output from the command line client.
2) The function from_unixtime(n) wraps on my server after 2^31 seconds.
e.g. select from_unixtime(2147483648) returns "1900-01-00 00:00:00". I
suspect this is caused by the underlying time_t size that mysql was
compiled with. Is this so? Are any versions of mysql compiled with a
larger time_t?

+---------------------------+
| from_unixtime(2147483648) |
+---------------------------+
| 1900-01-00 00:00:00 |
+---------------------------+
1 row in set (0.00 sec)


mysql> select unix_timestamp();
+------------------+
| u................................

View Replies !
Using CURDATE With UNIX Timestamp
I have a table where the dates are stored in UNIX timestamp format. I'm trying to use the CURDATE term for a select query but it isn't working. Does CURDATE work with the UNIX time stamp?
Any help is appreciated.
here's the query:
select first_name, last_name, date_expires, title
from cl_member, `user`, cl_chapter
where cl_member.user_id=`user`.user_id
and cl_member.chapter_id=cl_chapter.chapter_id
and cl_member.chapter_id=14
and month(date_expires)=month(CURDATE())
ORDER BY last_name

View Replies !
Unix Socket Vs TCP Mode
Our mysql database always run smoothness, but there have a strange question always happy.
We retrieve content using unix socket mode is always Correct, using TCP mode sometime will meet no return Error. What's wrong with TCP mode?

For example, We need to retrieve content from table Tab_Memo, the condition with ‘large’ is over 20KB, with ‘small’ is about ‘5KB’.

Using unix socket mode:
----------------------------------
mysql -u root -p password
1、select * from Tab_Memo where name = ‘large’; // The result is Correct.
2、select * from Tab_Memo where name = ‘small’; //The result is Correct.

Using unix socket mode
----------------------------------
1、select * from Tab_Memo where name = ‘large’; // NO result return.
2、select * from Tab_Memo where name = ‘small’; //The result is Correct.

View Replies !
Mysql Unix Client
I there, I would like to know if there is a mysql client that we can use from unix to connect to a mysql windows server?

View Replies !
TimeStamps In Unix-Format
In my database i have to work with timestamps in unix-format like '20070101000000' for 2007-01-01 00:00:00.

Now i have to look for the summary of the difference of two timestamps. The single difference of the timestamps are between one minute and about 15 hours. Now i don't know how to manage the correct sumary that should give me how many days, minutes and so on are summed.

View Replies !
MySQL Via Unix Sockets
I'm using java+JDBC connector. Where do I need to set up something to work with /var/lib/mysql/mysql.sock

View Replies !
Two Versions Of Mysql On Same Unix Box
I have mysql 3.23.58 version running on my unix box. I installed a new application on it which need mysql version > 4.0 so I thought of having two mysql versions running on the same unix box. I have first installation in /usr/local/mysql and I untared the new version in /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23.

I am following instructions given in http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html I also created a empty file and named it as mysql.sock.new and stored it in /var/local. When I try to start this new version from /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23 using ./bin/mysqld_safe --datadir=/var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23/data & it says "A mysqld process already exists". Please tell me where I am going wrong and how to configure it properly?

View Replies !
Selecting By Unix Date
I'm trying to do a very simple thing: I have in my DB a row called at_date, in it I enter a 10 digits number of date, like: 1171869716.

How can I select all the data from the table where the month is the current month (and year of course), or any month I choose?

Better saving the dates in a different format?

View Replies !

Copyright 2005-08 www.BigResource.com, All rights reserved