MYSQL :: Special MySQL Admin

What Do You Use For Mysql Admin?
what you all use for mysql administration? i know learning for the command line is essential but sometimes that takes too long and a gui is needed. I've been using phpmyadmin forever. is there anything else out there faster better more useful?

MySQL Admin
have just installed it and am having no luck getting past the Server Instance. I put in the Server host as "localhost, the Username as"root" and the password I created at the beginning. I hitOK and I get this message...

"Administrator for MySQL Servers has encountered a problem and needs to close. We are soort for any inconvenience." I made sure that Port 3306 was available.

Best MYSQL Admin
Besides PHPMyAdim, What is the best, easy to use, administration tool to use on a windows machine. Gui type? Also free?

MySQL Admin
I am having problems with my DB, basically i am not able to load mySQL Admin script in Ensim. First where is the location of the mySQL Admin script because in the spot i expect to see it there is no folder.

MySql Admin
When I boot my computer the MySql Admin window appears on the desktop. The only way I can close it is my clicking theHide Me button.
I get fed up of this routine everytime I boot the computer.
Does anyone know there is a way of keeping this window hidden so that when the computer is booted up it doesn't appear.I don't use MySql admin anyway as I connect through PHPMyAdmin.

MySQL Admin
I created an instance using "MySql Server Instance Config Wizard" then opened MySql Administrator, where I was asked to supply a user name and password for the connection. I did not supply a user name creating the Instance. Is there a default user name? How do I login? Windows XP OS

MySQL 4.0.xx Admin And Usage
I've recently taken over my non-profit's Web site design, administration and maintenance with relatively little MySQL experience (although I have learned a great deal very quickly). My question is, does anyone know where I can get a manual or something like the current manual "Building your Own Website Using PHP and MySQL .."(ordered from sitepoint.com site). This manual is basing the MySQL on the most current version of 5. I'm looking for something similar that addresses the 4.0.xx(27 specifically) of MySQL

Admin Tools For MySQL
What admin tools do you recommend for managing my MySQL databases.

In the past, I have used DB Tools, but now its not free, http://www.dbtools.com.br/EN/dbmanagerpro/

How To Set Up An Admin Password On OS X For MySQL?
I use to use Complete MySQL, I decided to use MySQL from here, just do to the fact of the major bug that C.MySQL contains now...

But the problem I am finding with the documentation is that it doesn't explain in OS X, how to create the admin account, and how to give it a password as well..

Transfering Another Db Into MySQL Admin
Is there anyway to upload a database into MySQL that is not a MySQL database.

Admin User In MySQL 5.0
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install
from blastwave). This is my first time with MySQL so I don't have any
exp with it.

I have some troubles as:
- I set password for root account via this command:

# mysql -h atlantis -u root mysql
mysql> update user set password=PASSWORD('123456') where user = 'root';
mysql> exit

However, I can login again with root account without pass check ????

- Next, I create new user name admin
# mysql -h atlantis -u root
mysql> create user admin identified by 'admin' ;
mysql> create database newdb ;
mysql> GRAND ALL ON newdb.* TO 'admin' IDENTIFIED BY 'admin' ;

Once again, i can't use admin account to login to newdb database?

Trick MySQL Admin
There are a few features in mysql administrator that are only available if you are connected to a localhost...this is useless if you are using a remote web server, linux based and need to monitor some of this information.

Anyone have any idea if there is a way to allow the following functions to work without local host?

Service Control: Start/Stop Service, Configure service
Startup Variables
Server Logs: Error Log, Slow Query Log, General Query Log

Is # A Special Character In Mysql
i had a problem uploading data containing "#"?? Is this a special character in mysql?

MySQL - Special Characters
This query (run in a bash shell script):

SELECT *
INTO OUTFILE '$EL_out'
FROM `HelixDump_EL`;

gives me a file with the special Icelandic characters corrupted. However, when I skip the INTO OUTFILE bit, it prints everything correctly. What is even stranger is that this used to work, and the structure of the database hasn't changed, so I am quite puzzled by this.

MySQL Admin Backups Won't Work
Iâ€™m using MySQL Administrator and MySQL Query Browser and want to make a backup of a database. First you click on the â€œNew Projectâ€ button and name the project. Next the documentation for MySQL Administrator saysâ€¦

â€œTo choose the databases and tables that will be backed up, select the database from the schemata list and click the > button. Once the database is in the Backup Content list, you can un-check specific tables that you do not wish to back up. â€œ

That sounds straight forward enough â€“ it works like every other gui out there. The problem is you click on the database you want to backup and it doesnâ€™t become highlighted and when you click on theâ€>â€ button, nothing happens. Why?

MySql Admin Schedule Backup
Mysql Admin 1.1.9 (server2k3)

I would like to schedule a backup of my db with MySql Admin. The concept is fairly easy but I probably miss something since the schedule backup is not running...

I've created a new backup project - named the project - Selected the db

I've selected InnoDb Online Backup left everything default

Last I've set a scedule backup every day at 23:00 with a target folder and file name

Do I need to do something more ? The scedule task is not running at all, the only way I can backup my db is by running it manually.

Error 1064 In MYSQL ADMIN
I am trying to run an SQL script using File -> Open Script.

Everything is working fine until one of the INSERT commands has a backsalash

insert into configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('9', 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language's currency when it is changed', '1', '10', NULL, '2004-11-03 12:36:43', NULL, 'tep_cfg_select_option(array('true', 'false'),');

In the code above the word "language's" seems to be creating an error. How do get round this problem?

Restore From Backup With MySQL Admin
I am trying to restore a mysqldump txt file to another cpu using MySQL Admin. I receive an error:

The selected file was generated by mysqldump and cannot be restored by this application.

I understand there are other ways of transfering a database to MySQL on a different cpu.
ie. mysql -u Username -p DBname < Filename.sql

When I try this it doesn't work I'm doing something wrong. Does the "filename" need to be an exact path to the file or just the file name ie. C:folderfolderdatabase.sql

Also does it matter if the file is .txt or .sql?
Does it matter where I have the database.sql file on my computer?
Do I need to have a new empty database created?

MySQL Admin Scheduled Backups
Two problems:

1.--

MySQL Administrator will do backups manually and for sometime it did scheduled backups, as well.

Now a scheduled job will fail and generate an event id 1000 error:

Faulting application MySQLAdministrator.exe, version 1.2.3.0, faulting module MySQLAdministrator.exe, version 1.2.3.0, fault address 0x001e5342.

2.--

The SQL error logs have disappeared since starting the use of Administrator for backups. Is there a way to get them back or at least start the recording again?

The only thing that ever showed up in the logs was the shut down and start up of the MySQL service at the beginning and end of a flat file backup of the entire database. Still... it would nice to have the logs back.

MySQL Admin InnoDB Backup
I'm having trouble backing up my InnoDB tables. The structure is backed up but the data isn't. I've tried every option that MySQL Admin offers. Does someone know of a solid way to backup InnoDB tables whithout bringing the database offline?

MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so:
I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns.
After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit.
Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.

MYSQL REGEXP (Special Characters)
I am currently using PHP and MYSQL, and I would like to know all of the characters I have to denote with a backslash .

I know perl and php are ". + * ? [ ^ ] $ ( ) { } = ! < > | :"

What would MySQL be?

Backup Options Non Functional - MySQL Admin
I have inherited a small MySQL database, version 5.x.

I have installed MySQL Administrator. I would like to try the backup utilities offered in this application, but they are all greyed-out and non-functional. It doesn't matter whether the application is run on the local host or on a client workstation -- the backup features are non-functional.

Replace Special Chracters In MySql DB Field
I need to replace all " and ' characters in a field i have (mysql database).

This field's name is "short_desc" and its type is "text". I'd like to do it by running an sql query via phpMyAdmin on all the data it contains.

" should be replaced with "
I think that ' should be replaced with ’ (right?)

What query should i run to do that ?

Inserting Special Characters Into MySQL Database
I am trying to add products to one of my clients' online shops and in the past it's all gone fine. I have a PHP script which handles a CSV file upload, digests the rows and inserts the data into a number of tables.

The upload I did today seemed fine until I realised that certain products have appeared with a ? in the name or description where there shouldn't be. Checking in the CSV, I find that the client has added a few hundred new products whose names include 'HahnemÃ¼hle Albrecht DÃ¼rer' (the product supplier) and other products whose names &/or descriptions include the micron symbol 'Âµ'. As you've probably guessed, the characters which are being replaced are Ã¼ and Âµ.

FYI, the site is still using MySQL 3.23.58 - I know it's old but we've just persuaded the client into a new .NET and MSSQL site re-design starting in a couple of weeks and we'll be dicthing that server so upgrading isn't an option.

I guess that I would be doing a search and replace for these characters in PHP (by ascii code?) and then inserting into the database. Then doing the reverse when displaying the product on the page?

How Can We Filter Special Characters From A String In MYSQL?
In Oracle we use Translate function to filter special characters. How can we filter special characters from a string in MYSQL?

MySQL GUI Tools Query Browser/Admin Login
I've just installed the GUI tools so I can get a little help with queries and table design, and I am not able to log into the administrator or the query browser. The login screens show up, I enter all the correct data, then the form grays out except for the cancel button and does nothing. Doesn't even eat up any system resources, so it doesn't even look like its trying.

I've turned off all firewall settings in case that might have cause the issue and it still doesn't work.

MySQL Admin - Lost Thread On Specific Like Query?
mySQL win32 (4.0.22)

I am using mySQL Control Admin and seeing a lockup on a thread specific to a
like query.

select * from table1 where field1 like 'http://h%' limit 100
This request will sit (thread) forever and never return any records. (status
: sending...)

However : select * from table1 where field1 like 'http://h%' limit 100
returns records immediately, no problems...

I have already run : /mysql/bin/myisamchk --sort-recover dbtable1, no
errors, no problems...

How can I tell what this thread is really doing or if any additional
problems exist with this table using myisamchk?

User Admin In Mysql-administrator Slow On Linux
We have a MySQL 5.0.16 server installed on a RedHat 8.0 machine.
mysql-administrator v1.0.22 is installed on RH Linux FC3 from the
mysql-administrator-1.0.22a-1.rh9.i386.rpm.

Everything seems to run fine except User Administration is *extremely*
slow. If I click on "User Administration" in the sidebar, it takes
about 2 minutes (seems like forever) before the window comes back with
the infomation. All the other functions seem to function fine.

Is it because I'm using mysql-administrator on a remote host? Do I need
to move and rebuild the server to a newer Linux version? mysqlcc
doesn't have this problem at all. (It's using the libraries from MySQL
4.1 that the databases were migrated to.)

Why Can't I Log In As Admin?
I am using MySQL 5 with PHP 4 on localhost. I was able to login fine yesterday as root but this morning I was unable to. When I type my password in the client it just dies. I know this is a very general question. If anyone is familiar with PHP, this is the error I get

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:wampwwwLivemysql_connect.php on line 8

Php My Admin
I recently started using PHPMyAdmin, just figured out that it goes to XAMPP's MySQL/Data folder... with the extension of MYD

I have some questions

1) Where can I get a free MYD database reader/editor not free trial but free
2) I have a bigger problem with PHPmyAdmin

I create 2 Fields: Name, Comments

but when I create it , it does not show me the table... How am I suppose to edit the records in the fields? I know I can, I just dont know how...

3) Some basic questions:

a) how to make an input mask
b) how to make an ID that is in MDB called: Autonumber

4) Is there an editor for MySQL databases like Access and is MySQL Server 2005 one of them? if not what does it do?

My Admin Accesss
I'm new to SQL server and having an issue. We have databases stored accross two machines. The structure and records can be accessed by authorised users through the myadmin page. This points to 1 server and its databases and directories can be viewed but I also need the databases on the other server to be viewed through it aswell. I can't see anywhere on the myadmin page which will allow me to set this up.

Web Admin Page?
is there a web admin interface that is included when installing MySQL?

If so, what is the url (e.g. http://localhost/mysqladmin)??

I am getting into programming in PHP and want to use MySQL on my development machine (they will both be on the same box to run concurrently).

It's a Windows machine running IIS 5.0

ENUM And Php Admin
Creating database in mysql using php admin, if I pick the datatype Enum and the if I have values for enum 'view' and 'url'

. Where do i put these values. I mean would it be in Length/Values colum or attributes?

Remote Admin
how can i remote admin the mysql (i am using mysql 3.23.)
and how can i create users for the remote control (using phpmyadmin 2.2.6)

Assign Admin
Is there a way to have a user in MySQL to be able to add databases, create users, and full access to the databases he/she setup? But not being able to access the other databases on that same server.
Also being able to add users whenever they like.

ENUM And Php Admin
Creating database in mysql using php admin, if I pick the datatype Enum and the if I have values for enum 'view' and 'url'
. Where do i put these values. I mean would it be in Length/Values colum or attributes?

Php Admin Tool
I recently upgraded from phpmyadmin 2.5.0 to 2.6.3-pl1. I cannot find the functionality to 'load text files into tables'.

Admin Rights
IM RUNNING A PHPBB FORUM WITH MYSQL...PROB IS NOW SOME GUY HACKED INTO MY PHPBB FORUM AND CHANGED MY ADMIN PASSWORD..NOW A FRND TOLDME THAT I HAVE TO GOTO MYSQL AND RESTORE MY ADMIN RIGHTS /I HAVE TO MAKE A NEW ADMIN ID..NOW CAN SOMEONE TELLME HOWS THAT DONE

Special Search
I have have upcids that were stored without 1st and last character and some have the hyphen at a point in the middle. Some have a plus sing at the beginning.

I'd like to know of a way or steps to pull the data up meeting proper 12 digit UPC-A format as one nice number, no '+' or '-'.

Or at least a way to filter out the characters I don't want and add those I do at the proper place.

Special Charac
I'm inputing text in a table with special characters (Spanish and Portuguese). They seem OK when I browse the table in PhpMyAdmin, but the query doesn't display right in Firefox nor IE (sub. by little squares or question marks).

I have the charset utf-8 declared in the html files.
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_general_ci
Collation for each text column: utf8_general_ci

If I substitute text in cells (by é, for instance) it displays OK, but I wouldn't like to do this for every entry.

- How to make it display right?

- Is collation for sorting characters in different orders only, having nothing to do with my current problem?

Special Char
I've done on Macintosh a solution to export data from FileMaker and Import in mysql.
I export, by ScriptMaker, a txt file, upload on my server with applescript and then I update the Mysql database with LOAD DATA INFILE.

But, the file txt contain special character, and I don't know what can I do to resolve this problem. Mysql when I LOAD the txt file change the character with other strange char.

I can't use backslashes in automatic mode because my fields are delimited by " "..

Special Characters
I'm new working with mySQL and I'm having trouble dealing with special characters...

Every time I try to insert data on the database containing special characters (i.e. "nÃ£o" ou "jÃ¡") the dbms returns the error: "Data too long for column 'xxx' at row n.".

I use MySQL 5.0 and Windows XP SP2 Pro.

Here are the values of the variables like "character%" and "collation%" (The charset directory is ok, only the file utf8.xml is not in there, but it's compiled into the dbms so I think thatÂ´s not a problem... hope I'm not wrong): Code:

Special Characters
I am looking for a way to parse out certain characters when I write a select statement to an outfile.
I know how to escape the characters w/ the escaped by clause, but I need to parse off some double quotes and some backslashes.

select id, name from artists where id in(14346, 25919, 76150) INTO OUTFILE '/tmp/test_5.csv' FIELDS TERMINATED BY ',' ESCAPED BY '' LINES TERMINATED BY '

Special Characters
ok the text for my site is in database only i have problems with quotation marks that screw up url's and stuff.what you think is a efficient solution for displaying & #8221; instead of "
but without changing it for real in all the data

Special Character
how to ignore special characters in select statement.
Say in mysql db I have table product. Under that I have a field p_name and say it has four records
Zenith 1234
Zenith (1234)
Zenith - 1234
Zenith /1234

Now say if I have a search from and a user enters zenith 1234, then it should show all the above four records and ignore these - ( ) - /

Select * from product where p_name like '%$formvalue%'

And is $formvalue = Zenith 1234 it should show me all the above records and not just 1.

Special Characters
Smetime ago I posted a message about MySQL not dealing with characters other than the very basic set. It cannot deal with french characters such as é and à. It just ignores them and whatever is after.It seems to be a 4.2 issue, as I think they changed the way MySQL deals with character sets.I cannot resolve the problem. I cannot store characters in MySQL other that the basic set of english characters. Anyone had to cope with this issue before??

Special Characters
how can i fit the special characters in my data base?
like 10h am Ã 17h pm
French language it is suppose to be à

Special Characters
i have developed a Content Management System using ASP.NET and MySQL database.

While submitting the Content, the MySQL tables aren't accepting single quote('), Double Quotes("), html tags (<br><font>) long dash(-) etc. that are there in the news stories.

Please visit http://67.18.142.206/newlayout/dec22002/1619320021213.aspx

to see the problem.

Can anybody tell me how to store them in the MySQL tables. i am aware about PHP Addslashes & stripslashes but they don't work with ASP.NET i think