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..
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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/
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.
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
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 Password() & Unix Crypt Password...
I am creating a user administration system where system administrator can activate services for a user, like webspace, a mail account or a subdomain. I now want to create a function that creates mysql databases and grant the right privileges to a user. But the problem is that mysql wants to have the plaintext password for the user in the "grant ... identified by 'pwd'" field, or in a manual query to update the password in the mysql.user table with PASSWORD('pwd'). I have another database which holds the passwords for the users, these password are stored the moment a user signs up and are used to activate services, for example ssh access to the machine. The stored passwords are encrypted using crypt(). So for adding a ssh service to a user, I simply do echo "$user:$pwdhash" | chpasswd -e. I have chosen crypt because some programs (like proftpd) don't take md5 sums. The problems is that I don't have the plaintext password. So I cannot add a mysql db. So I need to create a user in mysql with a crypt password. I tried to just "grant all privileges ... identified by 'nothing'" and then afterwards update the mysql.user table and putt the crypt password in there but it doesn't work like that. Does anyone have any idea on how I could fix this, how can I create a user in mysql without having his plaintext password and only having a crypt hash of it. I thought about not only storing a crypt hash, but also an md5 hash and a mysql PASSWORD() hash.. but I think that's an ugly solution.
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?
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.)
Random Password Vs. User Created Password For Site Login
Are there any security issues or other concerns that make one preferable? The client is pushing for user created passwords. I'm mapping out the basic functionality and front-end for a MySQL/PHP back-end that will be completed by a third party. I'm a novice to MySQL but familiar with PHP and their interaction. Mainly looking for anything to support one method over the other.
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
Create An Admin User
I need to create an admin user for my mySql database. I am using phpMyAdmin for a manager.
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.
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?
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.
I Can Connect With Db Password Or Blank Password
I have a password setup for root (% and localhost) in Mysql 5.0.26, I can connect ok no problem. I can also connect with blank password! I know it is checking the password cuz it fails if it's wrong. I'm sure I have only one account as well (tried to delete, recreate, etc... no change) select * from user where user='root'; | localhost | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... | % | root | *F3AD8B3C44772C17F66767F29D948D9C255BD824 | Y ... Is there an option to accept blank password!? I have this problem only for root user; Other accounts are fine.
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.
Using Password In Mysql
I used the below query for setting password. SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd'); After using it I cannot enter into mysql. When I entered mysql.exe, it is not going inside. But when I use mysql.exe -u root, its going inside. I don't know where the password was actually set.
Cannot Set MySQL Password On My Mac
I had an old version of MySql on my Mac. I recently installed the latest version of MySql. I tried to set a password in terminal using the steps shown below, but I get the error message shown below. I don't remember the password for my previous MySQL installation. Welcome to Darwin! localhost:~ helpprob% alias mysql=/usr/local/mysql/bin/mysql localhost:~ helpprob% mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I have also tried: mysqladmin -password <new password> and the same command without the dash before "password." I have also tried searching the MySQL manual and have tried various things that I thought it was recommending, to no avail. In some variations of what I have tried, I get the same error message except the end reads, "password: YES)
Mysql Password
When I launch phpmyadmin I can see a message at the bottom of the page which says : "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole." So I went into cli mode and changed the root password.(SET PASSWORD FOR root@localhost=PASSWORD('rubberchicken');) When I went into my moodle site I recieved a database error. I had made sure that I amended the config.php file to reflect the password change but to no avail. I then changed the password back to "blank" and everything works again. I have created a test connect page to rule out my application and it does not connect: <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'rubberchicken'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'moodle'; mysql_select_db($dbname); ?> I then change the password back to "blank" in my config file and mysql and everything works fine: mysql> set password for root@localhost=password(''); I am really stumped. I have restarted mysql and apache each time and flushed privileges.
How Do I Set A Password For MySQL?
Following the Open CMS installation documentation, I need to enter the following commands at the MySQL command line: use mysql; insert into user values ('localhost', 'opencmsuser', password('XXXXX'), 'N','N','N','N','N','N','N','N','N','N','N','N','N','N'); insert into db values ('localhost', 'opencms', 'opencmsuser', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); flush privileges;
Password For Mysql
I have running 4.0.15 on my server but when I access het database on a external network i dont have to fill in NO password. So everybody can mesh up my database. Can anybody tell me how I must handel so that i can set a password for my database.
MySQL Password
I just installed MySQL on my mac (OS X) and I'm trying to create a db with the following line command (and I get the following output too): [Jeremys-Computer:~] lezniak% mysql -p forum Enter password: ERROR 1045: Access denied for user: 'lezniak@localhost' (Using password: YES) [Jeremys-Computer:~] lezniak% Which says that my password may be incorrect or what? right after I installed MySQL, I put in: /usr/local/mysql/bin/mysqladmin -u root password <MyPassword> where <MyPassword> isn't what i put in, i put in my password. does anyone know what perhaps what the problem is?
|
TRACKER
