MYSQL :: End User Interface

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 !

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 !

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 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 !

Error 1142 - Mes. The Following Occured: SELECT Command Denied To User Xx@hostx.com For Table 'user
When trying to do anything to do with "User Administration" in MySQL Administrator 5.1 connecting to a remote MySQL database, I get the following message when I click on the "User Administration" icon/text in top left frame. Verbatim quote apart from my connection details which I am anonymising):

A MySQL error was encountered. The message is:

Could not fetch user names.

The following occured: SELECT command denied to user xxx@hostxxx.xxx.xxx.com for table 'user' (1142)

No I have looked through search and found the following:

http://lists.mysql.com/mysql/134369

Unfortunately that tells me that it has happened to someone else but that's about it. What is one supposed to do with the fix?

I am wondering if this is why I cannot create ordrop any tables with this username at the moment, even though it is the Admin level username....

View Replies !

Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database.

I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.

View Replies !

Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times.

So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries.

In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc.

Question #2:

I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all.

I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example:

To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily.

So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?

View Replies !

Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables
in different databases. Now I have to create serveral more users with
the same permission. Is there a command in MySQL that allows me to
create the new user by copying the privileges from a template user?

View Replies !

Retrive Category Names Where Categoryid Is Different From User To User
I am trying to retrive category names where categoryid is different from user to user

I know LIKE works with one int(1), but I want it to work with more ints (1,3,5)
SELECT * FROM `categories` WHERE categoryid LIKE (1) Working

SELECT * FROM `categories` WHERE categoryid LIKE ( 1, 5 ) Not working

View Replies !

Create User :: User Created But Password?
If I run the below statement as a user with the create permission turned on, the user gets created but without the password. Any suggestions?

CREATE USER 'fcms_testUser1'@'localhost' IDENTIFIED BY 'dumbpass12A'

View Replies !

Deleted Root User From 'user' Database!
I so stupidly deleted the root user from my mysql > user database. Now I can't login to mysql. I uninstalled the rpm and reinstalled it but it still won't let me setup a new root user. How can I delete the mysql data files so that I start again, fresh? Where are these files located? I can't find them anywhere after removing the RPM but they are obviously there because upon reinstalling the RPM I'm still in the same position--I try to do

mysqladmin -u root password 'password'

but it says "Access denied for user root@localhost"

View Replies !

Access Denied For User: 'user@172.22.0.1' (Using Password: YES)
I am currently running two servers one with Tomcat and the other with MySQL. They are both in different Windows domains and on different network segments.

I have the following users on the MySQL server:
user@localhost
user@%

I am getting a VERRRY SLOOOW connection between the two machines so I thought I'd add a user just for the Tomcat server. The IP address of the Tomcat server is 172.22.0.1 so naturally the user would be 'user@172.22.0.1' When I added this user I got the following error

Access denied for user: 'user@172.22.0.1' (Using password: YES)

Any ideas on what I can do to remedy the situation?

View Replies !

Deleted Root User From Mysql.user !!!
While trying to grant access to root user, i deleted all entries for root from mysql.user.

I've tried to use root% (anonimous built-in administrator user) but to no good).

Is there another admin user i could use to run mysql monitor and insert root records to mysql.user? I've read

Could I use a copy of the mysql.user table?

I'm using version 5.0.16-standard on Linux Fedora Core 3.

Before ruinin the root user, i made a backup of a databasefrom the same server (not mysql database); i was wondering if that backup contains the mysql.user information somehow?

View Replies !

User@localhost And User@domain.com
I have been following a tutorial for a mail server which uses mysql, mainly postfix

all through the tutorial i have been asked to put a user and password in the files for the database..

which i have done

root and pass1

in the log files the error shows as

warning access denied for user root@domain.com ( using password : yes )

when i log on from the shell, to mysql

and purpously get the password wrong, I get
access denied for user root@localhost ( using password : no )

i have checked the password is correct..

is the part after the @ the issue, and how can i tell mysql that root@domainname.com is a valid user???

View Replies !

Selecting User,password From User
When I do: select User,Password from user in MySQL, I get encrypted password. How can I see the real value?

And, what is the proper (secure) way to access MySQL database from PHP or other scripting languages?

View Replies !

User Problems... Only Root User "works".
i have been trying to figure this strange problem out for a week or so. here it is.

i have a set of users with various permissions for different reasons. about 2 weeks ago, my hardware suffered a fairly nasty failure. i recovered everything. things seemed to work out. i didnt think to check my phpBB forums or my blog (or other mysql based stuff). never had any problems with the DB... so, maybe i am missing something simple here. i hope so.

what my users can do:

they can log in via command line, a gui i use on mac os x and it does not matter if it is local, or remote. they work just fine.

what all but one users cannot do:

none of my users can run phpbb or the blog stuff.. except for the root user. any other user returns the error message written in the code of which ever script i try to access telling me that "could not connect to DB" etc..

root works fine.

now, i thought maybe it was a problem with the forums and other stuff. but i cant be. same thing happens with all things... even a game server i occasionally run that keeps account info in a DB.

all these users are set up properly and have worked just fine in the past. nothing new has been installed, no conf changes..im at a loss...

View Replies !

Changing User From One User To Another
Currently i have 2 Users in My MySQL(root,user1)...Whenever i am clicking command prompt Client its directly taking me to root user. If i want to change user (to user1) from there how i need to proceed...(Like connect in Oracle what we need to be use in mysql.

View Replies !

User Name
I'm trying to connect to mySQL through Dreamweaver, and got as far as the mySQL Connection box, where I type in my connection name, server, user name, and password, then search for a database. I'm using a tutorial for an online class, but it's not very clear about the user name. How do I get one/do I already have one? Could it be one I set up with phpMyAdmin?

Please keep in mind that I am as noob as they come, so I may need the techono-speak dumbed down a bit

View Replies !

User And Use DB
Using PHP and MySQL:

I know I can use a connection string such as :
$mysqli = mysqli_connect("SQLSvr01","User", "Pass", "dB", Port);

Will I have a confined Query based on this connection or if my web site makes a query for a seperate dB at the same time from another user will they conflict.

or let me refrase

Is this connection isolated from all other requests, regardless of how many times the request is made, or is it dependant on the user or sever or database?

View Replies !

User: Any
I've noticed a user called Any in the MySQL privileges table. This user has 'useage' priv on host 'localhost' and 'build' ... should I delete this? Does it pose a security risk?Also, what's the host 'build' ?

View Replies !

Can't Create New User In 4.1.18
this is what I am doing:

mySQL> GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON store. TO
newusername@127.0.0.1 IDENTIFIED BY 'newpassword';

I have tried leaving out , LOCK TABLES ON
also just ,LOCK TABLES

it keeps saying:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'TO newusername@127.0.0.1 IDENTIFIED BY
'newpassword'' at line 1

I am using 4.1.18

View Replies !

User.MYD Broken
While doing a couple of grant statements I suddenly got the message that
user.MYD could not be opened. So I copied it back from yesterdays backup but
no luck. I restored user.MYD, user.MYI and user.frm and after that the whole
mysql directory in /var/lib/mysql but the server now refuses to start. What
can I do?

View Replies !

User Question
I am new to MySQL and recently took over the MySQL from someone who
also did not know what they were doing. I recently installed
PHPMyAdmin to better manage the box but I noticed that the user table
looked like this:

User Host Password Global privileges Grant Action
Any % No USAGE No Edit
Any localhost Yes ALL PRIVILEGES Yes Edit
root % Yes ALL PRIVILEGES Yes Edit
root localhost Yes ALL PRIVILEGES Yes Edit

My question is, why is there 2 any and 2 root users? Don't I only
need the root@localhost and any@localhost? What would be the best way
for me to find out if these users are needed?

View Replies !

Remove User But Still Can Log In
I use the command to create a user and grant all privileges to this user,
then I delete this user from the user table but I can log in use this user.
Why ?

grant all privileges on *.* to john@"%" identified by 'john'

I then delete the user 'john' from the user table in mysql database.
But then I tried to log in using this user successfully.

View Replies !

Cannot Create User
I have a problem with mySql server: I can only run it as root. I use
mySql 4.0.15 and phpMyAdmin 2.5.5. on Mac OSX 10.3.2.

I run mySql server as root, log in via phpMyAdmin as root and I see
there is no user mysql when I click 'Privileges'. When I try to make
new user 'MySql' (with minimal privileges) and click 'Go' I get an
error 'unknown command'. The corresponding mySql statement is:

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX ,
ALTER , CREATE TEMPORARY TABLES ON * . * TO "mysql"@ "%"IDENTIFIED BY
"*****"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 ;

#1047 - Unknown command

How can I log in as user root and not have Grant privileges???
More importantly, how can I create a user mysql with the normal set of
privileges (update, create, alter etc)?

I have been using the procedure described on the mysql.com website
'A.4.2 How to Reset a Forgotten Root Password' to reset the password
for root.

View Replies !

Create User
I have a problem with mySql server: I can only run it as root. I use mySql 4.0.15 and phpMyAdmin 2.5.5. on Mac OSX 10.3.2.

I run mySql server as root, log in via phpMyAdmin as root and I see there is no user mysql when I click 'Privileges'. When I try to make new user 'MySql' (with minimal privileges) and click 'Go' I get an error 'unknown command'. The corresponding mySql statement is:

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES ON * . * TO "mysql"@ "%"IDENTIFIED BY "*****" WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

#1047 - Unknown command

How can I log in as user root and not have Grant privileges???

More importantly, how can I create a user mysql with the normal set of privileges (update, create, alter etc)?

I have been using the procedure described on the mysql.com website 'A.4.2 How to Reset a Forgotten Root Password' to reset the password for root.

View Replies !

A User Dba Privileges
I need to give a special user admin rights to the databases he
creates.

As there is no dedicated MySQL database server for his needs yet, we
created a special user on a multi-purpose MySQL server; this special
user has the rights to do everything only on databases he creates.

To distinguish his databases among others, we require his databases'
names to be prefixed by "PNCC_". Here's how we did the trick:

Once logged in as DBA:

mysql> GRANT ALL ON PNCC_.* TO fred@my.fqdn.com IDENTIFIED BY
'some_password' WITH GRANT OPTION;
(The query ran OK)
mysql> UPDATE db SET Db='PNCC_%' WHERE db='PNCC_';
(The query ran OK)

(We had to do two different commands, as GRANT does not seem to accept
wildcards).

From now on, after having flushed privileges, user fred@my.fqdn.com
can create databases with names prefixed by "PNCC_", create tables
within these databases, and populates them.

But this user would like to have the possibility to create users with
special privileges on the databases/tables he previously created. The
question is: how can I grant fred to create users with rights ONLY on
PNCC_<some name> databases, and nothing else (ie. no access to other
databases, nor on mysql.*)? Do I need to insert a special row within
mysql.user? If so, which one?

View Replies !