Setting Mysql Password
How do I set the mysql password? Are there separate password for every database I create?
View Complete Forum Thread with Replies
Related Forum Messages:
Setting Up The MySQL Password
I can't seem to see the page whan I am trying to set up the 'Setting Up the MySQL Password'. I know this is right at the start but all I get when I type in the Web browser http://127.0.0.1/myadmin is the sourcecode and not the actual log in page... I know it's something silly I have done or not done (I have installed the Apache / MySQL / PHP stuff over and over again, but it still does the same thing to me. The Apache services is running fine. The WinMySQLadmin is on green so I know that's fine. I think it's maybe an explorer thing? but I can't seem to get it.
View Replies !
Setting Password For MySQL From WAMP?
A few months back I installed WAMP (one big installation of Apache, MySQL and PHP for Windows). The last week I'm busy with Portal development. As a result I'm trying to install Jetspeed-2. The installer of Jetspeed asked what Database I would like to use. As I installed WAMP I thought it wiser to stick to MySQL. When I started phpMyAdmin I saw the following message: "Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account." As it is some time since I installed WAMP I cannot remember what I need to do. I searched the install directory and found that the word password is contained in several .ini files (my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.inim and my-small.ini, but not in my.ini). The format of the line is: #password= your_password I take it I need to remove the # at the start of the line, replace 'your_password' with a password of my choosing? But in what ini file? How does WAMP know what ini file to choose? In the same directory as the ini files I see a wampserver.conf file. In it there is an entry: $mysqlConf['mysqlConfFile'] = 'my.ini'; Does this entry make WAMP to choose for my.ini? I plan to use the WAMP/MySQL installation purely for development purposes.
View Replies !
Setting Mysql Root Password On Mac
Am having problems setting the root password for the mysql server on my computer. I'm using Mac OS X with apache, php 5 and mysql 4.1 installed. I've tried using the terminal utility but I've had an error message reading:
View Replies !
Setting Root Password For MySQL
I'm Using the "Build Your Own Database Driven Website Using PHP and MYSQL" by Kevin Yank. On pg. 22 where the arguments new password are in parentheses, I typed in new password instead of my own new password ( I know that was dumb!). Anyway, when I quit the Mysql and start over I get the error: cannot login to local host password not excepted. How do I restart so that I can create a root password for Mysql?
View Replies !
Setting MySql Root Password
I feel a bit daft as I can't seem to get passed p21 of Database Driven Website by Kevin Yank. But I'm learning Ive got the latest copy and and want to follow it through to see what i can learn (lots I'm sure) Im on a mac osx and am trying to set the root password. He says to do this using terminal in the bin directory of my MySql installation. Where is it? i know basics about getting round terminal i.e changing directories and stuff.
View Replies !
ERROR When Setting Password Via Console (MySQL V 5.1.30
I am trying to set a password via the console with the following: mysql> update user set pasword - password<'password'> where user = 'root'; and receive the error message: 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 'where user = 'root'' at line 1
View Replies !
Setting Password
I successfully added MySQL, setup db's and did initial app development. I did all of this under the root user and blank password. When I ported the new development to the web site I tried to setup a user and password for the application and set the root password and ran into a brick wall. I am now locked out MySQL in terminal mode, phpAdmin will not save a config, MySQL GUI Admin will not save passwords and under options it says it cannot locate the /etc/my.cnf file. I have looked at a number of tutorials to set up the my.cnf file and they seem to conflict with one another and have been reticent to take action to make sure I was going in the correct direction. I am using QS10.4, phpAdmin 2.11, MySql 5.05, GUI Tools for 5.0. Can anyone point me the right direction to line up all of the security related files to get control back, successfully run the app on the local environment and and continue development.
View Replies !
Setting Password Fails
The reported problem when attempting to set up a root password is; C:mysqlin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306' When checking this: C:mysqlin>telnet localhost 3306 Connecting To localhost...Could not open connection to the host, on port 3306: C onnect failed.
View Replies !
Setting User Password
I am having a problem getting mysql to recognize my user password. Currently I am doing everything on 'localhost' [CASE] My root password works; I have access and can create databases as root. I used MySql Administrator to create a user 'bill' and gave that user a password (billpw) different from root and applied most of the global privileges including 'CREATE'. I can open mysql with root and rootpw. As well, I can open mysql with user 'bill' and rootpw but NOT with billpw. [bill@CASE ~]$ mysql -u bill -p Enter password: ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) Even when I open Mysql with bill rootpw, I get the following: mysql> CREATE DATABASE menagerie; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'menagerie' I can CREATE the DATABASE as root. I have read Section 5.7, “The MySQL Access Privilege System” and nothing seems to apply -- but that could just be newbie ignorance. Do I have some Linux permission problem related to MySql or have I done something wrong when creating my user ? How can I check for the error?
View Replies !
Setting Password Problem
i've created my database and now i want to access it through php so im using:mysql_connect('localhost:3306', "username", "password") or die(mysql_error()); but i haven't yet set a password and don't know how to, so when i run the file it comes up with the error mysql_connect() [function.mysql-connect]: Access denied for user.Is this because i need to set a password and username,if so then how? or is it maybe another different problem?
View Replies !
Setting Up Password Fails
Having a problem setting up a password for MySQL The reported problem when attempting to set up a root password is; C:mysqlin>mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' (10061)' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306' When checking this: C:mysqlin>telnet localhost 3306 Connecting To localhost...Could not open connection to the host, on port 3306: C onnect failed
View Replies !
Setting Root Password
I am using MySQL 4.1 on Win XP.I forgot my root password and I am trying to reset it. I am using the SQLyog GUI to manipulate my DB.I have a guest password stored in SQLyog and can access all of my databases.But I can't use SQLyog to change the password b/c it uses the new password alogorithm which is hashed to 32 characters opposed to 16 in the old alogorithm.I was wondering a way to reset my root password. I only have minimal privileges on this account such as SELECT. Just in case anyone missed it, I can't log into my MySQL command line client since I don't know my root password.I would normally use OLD_PASSWORD('password') from there.
View Replies !
Authentication :: Setting Root Password
I am trying to set the root password, but all I get is: $ ./mysqladmin -u root password <newpassword> ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I have no problems connecting like this: ./mysql -u mysql In the latter case, I cannot do anything. For example mysql> CREATE DATABASE one; ERROR 1044 (42000): Access denied for user ''0'localhost' to database 'MoonlightDB'
View Replies !
Setting Password & Salt Then Cannot Login
I go into "phpmyadmin" mysql admin gui and set a passwd and salt for an account ..... i enter username as <usernametext> ... that is plaintext i enter passwd as sha1(<passwdtext>) so it displays in table encrypted i enter salt as <salttext> .... that is plaintext now below is authen logic for login .....
View Replies !
Setting Up Root Password For Mysqldatabase
I have Fedora Core 4 installed in my pc and I need to setup mediawiki. In the process of setting up mysql database (to create root password), I did as instructed, typed - 1. mysql_install_db 2. mysqld_safe it replies - Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 060323 15:22:34 mysqld ended but when I try to type mysqlshow, it gives this error instead mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I could not setup the root password for mysql bcos of this error.
View Replies !
Strange Password Setting Behavior In Fedora Core 4 (server 4.1.11)
I have tried adding users aided by several references and this typifies the procedure: http://dev.mysql.com/doc/mysql/en/adding-users.html But, I found that after adding them, I could not use them to get into mysql. I found my way to this reference, http://dev.mysql.com/doc/mysql/en/access-denied.html and on a hunch, set the password to '', that is, no password at all and find that now I can use them to get in. What is going wrong here? Also, I am finding that I cannot get into my database from a remote host, even though I use the '%' variable or even more directly, the actual 'RemoteHost' name.
View Replies !
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.
View Replies !
Setting Up MySQL On Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints?
View Replies !
Setting Mysql
I'm setting up mysql server for the first time and after logging into the command prompt I setup a new super user and deleted the root user for security reasons. Now it seems I can't login to the server at all. MUST you have a root user to run a mysql server? If not, how can I login to do anything?
View Replies !
Re-setting Mysql As A Service
I installed mysql server 4.1 last month. When I installed it, I set it to run as a service to start automatically. However, for some reason, that no longer occurs. I can't even see the mysql service running from services viewer in win xp. I now have to manually start mysql server each time I reboot. Can someone please tell me how I can Re-set mysql to run as a service?? Or, if I re-install mysql, will it retain the db's already created??
View Replies !
Help With Setting Up A MYSQL Database
I’d like help with developing a mysql database please. The situation is as follows: There are 40 teachers at our institution. Each teacher teaches 4 lessons (I’ll call them: CW, EW, DSS and LNT) – CW and EW are taught to two classes, and DSS and LNT are taught to two different classes. There are 5 syllabus items for each lesson that need to be covered for each class. The course runs for 10 weeks. I’ve calculated the number of unique records will be 16000 The coverage of each week’s content depends largely on the level of the students, the teacher and/or any supplementary material used. On my php page, if a syllabus item is covered teachers need to check it as completed (checkbox). Any additions to the lesson need to be added to a comments field (textarea). Teachers should be able to log into to see their records (stored on the mysql database and accessed through php pages) and then be able to filter their records by week, class and lesson using drop down lists. The question I have is: What is the best way to set up the mysql database so that each record is unique so that I can accomplish the above? Fields: ID(int), content(text), teacher(text), course(text), week(int), completed(int) and comment(text) Running MySQL client version: 5.0.51b on Windows XP
View Replies !
Setting MySQL Host
I'm looking to grant access to a MySQL database based on a range of IPs. I did a search on the forums here and couldn't find exactly what I was looking for. The IP range is actually only 2 IP addresses but I'm sure there must be a way of setting the Host to accept something like: 123.123.123.*.Currently I can't test it as I don't have access to the web servers, but it someone could tell me the surefire way of doing this it will be one less worry for me .
View Replies !
Setting Up New Mysql Accounts
I have followed the manual for MySQL 5.0 for adding new accounts to MySQL but it will not work for me. I am typing these commands on the root on the actual computer with Every time I input these following commands, the command just returns this: mysql> Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON *.* TO 'myusername'@'localhost' -> IDENTIFIED BY 'mypass' WITH GRANT OPTION; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON mydatabase.* -> TO 'myusername'@'localhost' -> IDENTIFIED BY 'mypassword'; I've also tried this one mysql> CREATE USER 'myusername'@'localhost' IDENTIFIED BY 'mypassword'; But it returns mysql> ERROR (HY000): Opteration CREATE USER failed for 'myusername'@'localhost' .
View Replies !
Setting Up MySQL Administrator
I just downloaded MySQL Administrator and am trying to install it. I'm trying "localhost" and "root" for Server Host and Username, along with the default setting for Port, 3306. However, I don't have a clue what a "Stored Connection" is. What am I supposed to enter there?
View Replies !
Configuring/Setting Up MySQL 5
Im a complete newbie to mac os x. I downloaded and installed mySQL 5. I installed it and now i cant seem to connect. I have absolutely no idea what im doing. Im not familiar with os x termial commands. I need someone to email me and explain to me everything i need to do in order to create a user and successfully login using mySQL admin. I've been struggling with this for over a week. Ready to pull my hair out. And please dont refer me to online resources, ive read them all and still cant figure it out. I need a professional who can give me a step by step process to get this going.
View Replies !
Setting Priviledges On MySQL
having a problem setting up users on MySQL, my database is currently running using the default settings. I have scoured the documentation for both PHPMyAdmin and MySQL and am still none the wiser.
View Replies !
Setting MYSQL Rules
i got table with one column of dates - time(). how i can set a rule inside the mysql -not on asp pages... the rule- take the maximum value and delete all the values that "smaller" than the maximum value, in 20 min
View Replies !
Setting Up MySQL On Mac > Leopard
PHP Code: $link = mysql_connect ("localhost" , "Cretaceous" , "Dinosauria") or die(mysql_error());mysql_select_db ("Trex", $link) or die(mysql_error()); and put it on a test page. When I preview it in a browser, it gives me the following error message: Code: Access denied for user 'Cretaceous'@'localhost' (using password: YES) I checked the privileges, as follows: User (Cretaceous), Host (%), Password (Yes), Global privileges (USAGE), Grant (No) It looks like my user name and password are OK. I changed the database name from Trex to trex (all lower case), but I get the same error message. Since the Privileges page lists the Host as %, rather than localhost, do I have to make some sort of change there? I replaced "localhost" with % in my database query but that doesn't work.
View Replies !
Setting Up MySQL Administrator (have WHM)
I would like to set up MySQL Administrator. (MySQL is taking up 50+ % of my CPU, and I'm not sure why...) I'm having difficulty connecting to my MySQL db. I'm fairly sure I have the correct username and password. For the host, I just used my server's IP and for the Port, I have 3306. When I try to connect, I receive the following error... MySQL Error Number 1130 Host '<IP address>' is not allowed to connect to this MySQL server. I tried adding <IP address> to the MySQL Access Hosts using WHM, but don't think it's working. In fact, I think when I initially tried it... my phpmyadmin stopped working and I had to go in manually to the config file and fix it up.
View Replies !
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.
View Replies !
Setting MySQL Parameters Via PHPmyadmin
What is best selection for 'collation' parameter - for those, who need use two languages, latin(english) and cyrillic(russian) on website and need that mySQL handled and stored both languages correctly? What need be specified in "MySQL connection collation" field?
View Replies !
MySQL Performance - Option Setting
I set OPTION=3 in my connection string as recommended by MySQL (http://dev.mysql.com/doc/refman/5.0...parameters.html) for a VB application. OPTION=3 is Don't Optimised Column Width (1) and Return Matching Rows (2). I found this to be very slow on a database with just 27,000 records. It took approx. 12 seconds to read 27,000 records. When I change the OPTION to 8 (Allow Big Results), it took just 3 seconds to read 27,000 records. BUT now my application cannot update records anymore and getting random errors on transactions. I try setting OPTION=11 (all 3 options added together) and the speed went back to being slow.
View Replies !
Setting Up Mysql Tables For UNICODE
I am willing to setup my MySQL tables so they can hold international strings (English, French, German and Spanish). I understand that Unicode character coding is a good candidate to do so. Currently I use the default character set and it looks like it does not like characters such as "", "" .etc... (they come up as strange characters probably indicating that the code of the character has been truncated). Is my understanding correct? If yes, could anyone lead me through on how to create such tables coding text as Unicode? I went through the MySQL administration guide but cannot get a clear understanding on how this is supposed to be performed. Ideally I would like to setup the MySQL *server* for it to process the tables with the Unicode character set *by default * (rather than specifying each tables one by one as using Unicode encoding).
View Replies !
Setting Up Initial Accounts In MySQL
I'm a newbie to MySQL. In setting up my initial accounts, I see two anonymous users in the mysql database in the user table. My book says to delete them which I did, but I still see what looks like two root accounts. Is this normal? If not, which one do I delete? I see one doesn't yet have a password; should I delete the one without a password? First I'll log out and log back in as root to see if that other root user is a phantom or is really an account. Next, I'll need to add a few users, but I need to make sure this root thing is correct. Here's a screen shot of wht I did: mysql> use mysql Database changed mysql> select user.user from user; +------+ | user | +------+ | | | root | | | | root | +------+ 4 rows in set (0.02 sec) mysql> delete from user where user=''; Query OK, 2 rows affected (0.01 sec) mysql> select user.user from user; +------+ | user | +------+ | root | | root | +------+ 2 rows in set (0.00 sec)
View Replies !
Sorting Columns. Setting Up Mysql ?
Interested in setting up information in columns to sort in ascending and descending order. I'm hoping to set up a clickable image for both options. I know basic html design, I'm just not sure where to start in mysql. Not sure how to set up the table and where to link them to php pages.
View Replies !
Setting MySQL Variables At Start Using My.ini
I am battling to set the default datetime_format in my.ini, if i add the line i want to change the setting, the service refuses to start! The line i am adding is as follows: set-variable = datetime_format="%y/%m/%d %H:%i:%s" Am i doing something wrong here?
View Replies !
Setting Up A MySQL Server With SBC Webhosting
So I got into my Database Tools section and all I have is this: * Documentation * File Importer * Monitor Table maintenance and testing * Schema Viewer View table definitions * Database Dumper Export table contents and definitions Special Notes: * Access to your MySQL Database will require that you supply your userid and password. * Download myodbc, a Windows 95/NT ODBC Client, from the MySQL Homepage. * For ODBC access use port 3306. There is NOTHING that tells me WHERE to access my MySQL Database, and myODBC does nothing for me because I don't know where my Database is (I've tried using it to in various ways and can't get anywhere). I have no idea what to do with that port number. Could someone help me out?
View Replies !
MySQL Setting Collation To Latin1_swedish_ci
No matter how I configure MySQL 4.1.9, I always end up with all of my tables having collation set to "latin1_swedish_ci". I have tried setting the collation to "latin1_general_ci" but my settings are ignored and all tables show up as "latin1_swedish_ci". The tables that were created have been created and all data inserted through a PHPMyAdmin SQL file export under a server running MySQL 4.0.22. Is there any way to fix this and what is might be causing it.
View Replies !
Setting Up PHP And MySQL To Work Togather.
I can't get MySQL and PHP to work. I've installed MySQL ver.5.0.3 or so on my PC (winXP) on my D: drive, after that i've installed Apache2 serv. also on the D: drive and afterward came PHP5 as a Apache module. I've tried testing if it works. Code:
View Replies !
Setting UP MySQL To Work With Dreamweaver And PHP
I'm trying to set up Dreamweaver to work with PHP and MySQL but cannot get Dreamweaver to recognize my database. I currently have PHP running under Microsoft IIS on my Windows machine and MySQL installed and running. I'm accessing it through MySQL Administrator and also MySQL-Front and don't have any problems connecting to the database in either of these programs. I've set up a DSN for the database, under ODBC Data Sources, and I'm using a virtual directory under IIS for the web pages I'm developing. When setting up a database connection though in Dreamweaver, I get an error message that says "An unidentified error has occurred" As far as I can tell, I have MySQL set up for Root access and also anonymous access. Any suggestions about what I'm missing to get this to work?
View Replies !
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.
View Replies !
|
TRACKER
