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?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.)
Create An Admin User
I need to create an admin user for my mySql database. I am using phpMyAdmin for a manager.
Need To Create A Limited Admin User
I need to create an admin user with limited rights who can create databases and then grant full rights to these db to another user. If I give the admin user full root privileges (grant all on *.* to 'user'@'localhost' identified by 'pw' with grant option) it works, but I don't want to do this for obvious reasons. What privileges does this admin user need to do just these tasks?
First Time Install On Windows - Admin User&password Problem
I have a problem with logging in to MySQL. Access denied. I think the issue is with the host, user and password settings. I assumed you had to add this information to the my.ini before you started the service for the first time. Is this only for WinMySQLAdmin? Is there a default? I have tried all the solutions I could find but they seem to all require user privileges in the first place. I simply need to have one main admin user and password and to refresh their values to be certain of the new settings in case there was one before.
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..
Special MySQL Admin
I’m looking for a solution to create a limited numbers of MySQL-Databases. In other words a front-end for users. The software AutoControPro (www.directphp.com) has this feature, but is very expensive to buy the soft only for the My-SQL feature. I should have the possibility to limit the Databases for every user and the user should have the possibility to create the appropriate numbers of Databases. Example: User1 can create 3 MySQL-Database User2 can create 5 MySQL-Database If the User installs phpMyadmin he should get only the assigned Databases.
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
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.
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.
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?
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?
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
Admin Login Not Accepted
I am trying to setup third-party php software on a hosting domain. I have no trouble at all setting up the communication with the mySQL database, and the software creates the needed tables in the database without trouble. Only when I am done, it is not accepting my login in the site structure. I have asked support by the developer of this third-party software but after trying several solutions we have come to the conclusion that the error does not lie within the third-party software. I have tried several times to make changes in the database, deleting it, make anew, do reinstall on the third-party software, completely delete and re-upload third part software all resulting in the same error over and over. It says im not a member (even tho account is in database and is active) or my connection has timed out. Perhaps anyone can shed some light on why I cannot log in to the website structure with my freshly created admin account even though the tables within the database as well as admin account have been created.
Admin Focused Book
I am looking for a good MySQL book with in-depth coverage of Administration topics. Something written for a DBA, not a programmer. I am trying to expand my skill-set and cannot for the life of me find any books that go into detail enough on Admin Tasks. I was in a few local book stores this weekend and could only find books geared towards the programmer or first time SQL user. That part I know already.
MYSQL User Information: Error While Storing The User Information
I have a proplem creating a new user and/or adding additional information for root user in MySQL Administrator 1.0.19. When I do I get this message: error while storing the user information. Never the less, when I close the Admin program and open it again, the changes I tryed to make are saved, (althoug the program asked me if I wanted to save changes and I said no) Is this a know bug, should I be alarmed, any solutions ? I´m running MySQL 4.3.11 Admin 1.0.19 Query 1.1.5 Apache2 php5
GUI Admin Console Login Problem
This is a follow-up to thread436-1281656. I successfully installed MySQL database engine.I can access the database from the command line without any problems.I used the standard MySQL username and my own PW. I then installed the MySQL GUI features such as the administrator.I started the server, from windows, and tried to login.However, it will not let me.I am running locally and used localhost.I am including the screen shot of the Admin and failed login. I am able to ping the box successfully by pressing the ping button.
Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!). I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection. What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used). I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.
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.
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
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?
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"
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???
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?
|
TRACKER
