When Restarting The Service, Blank Password
When I stop the service and restart the server, it takes blank/wrong password for any user account including root. Only after I reset the password for root, then the passwords for all the other accounts work fine. What is causing this problem? I don't have the root with % host. And all users under user table in mysql database has passwords set.
View Complete Forum Thread with Replies
Related Forum Messages:
Blank Password When Restarting The Machine
I mainly use MySQL Administrator to create/update table/users/etc. And I noticed that whenever I restart my machine (Windows 2003 Server with MySQL database running) and login to the MySQL Administrator, it takes blank or wrong password for any user account including root. So I end up resetting my root password. Does anyone know why it keeps happening?
View Replies !
Restarting MySQL Service Resets My Privelages
When i restart my MySQL service in Windows all my priveleges are reset for my Databases. I can then no longer access the database(s) in my scripting. I am using the GUI through Control Panel > Administration Tools > Services and not the command line 'net stop mysql'. Why would this occur?
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 !
Root Password Blank By Default?
I installed mysql correctly I am assuming navigated to mysqlin and ran mysqladmin C:Program FilesMySQLin>mysqladmin -u root -p password Enter password: *********** mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' C:Program FilesMySQLin>mysqladmin -u root -p password Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I am unable to log on as root and change the password. It says leave the password blank by default. I still will not let me connect. Do I have to start mysql.exe and type the mysql admin -u root from there
View Replies !
Mysql Service And Root Password (-w W)
I have a few qeustions for some linux/mysql pros in here. Background: I've just built MySQL on Mandrake Linux 9.1 from source. I can get the mysql service running my: shell> /usr/local/mysql/bin/mysqld_safe --user=mysql & but I don't know how to keep it running, or how to make it start at every bootup. How do I do that? Also, I've made an alias to mysql: alias=/usr/local/mysql/bin/mysql but it won't span sessions, I think I need to export it, but I'm not sure how to. Also, via mysqladmin I set the root password to "password" which I don't want to keep :) how do I got about changeing it now? I know I probably should have installed via RPM, but I'm wanting to learn as much as I can about all of this.
View Replies !
Restart MySQL Service After Root Password Change
I installed mySQL on a Win2k machine and tried to change the root password, which didn't seem to work. I changed it this way: c:>mysql mysql> use mysql mysql> update user set password=PASSWORD('test') where user='root'; mysql> exit and then tried to login this way: c:>mysql -u root -p password: test which didn't work. Then, after many unsuccessful attempts, I restarted the service and suddenly the password I had set worked. Then I realized that (at least for the root password) I needed to restart the mySQL service everytime I changed the root password, otherwise it would not become effective. Is this by design??? Am I doing something wrong?
View Replies !
The MySQL Service Has Disappeared From Win XP Service List
I have been using MySQL for about 3 years now on Win XP Pro SP2 and had no real problems. Until today I went to start the service in windows service list (I start it manually) and it was gone! The MySQL install (MySQL 5.0) is still visible in add/remove programs and all the files and directories are present.
View Replies !
Restarting Mysql
I am brand new to Mysql. I just shut down my sserver and whenever I go into another window in the command promt, it says that it could not open up a connection to the host. So what I'm asking is, is how can I turn my server back on?
View Replies !
Restarting With Mysqld_safe
The documentation says to restart mysql, do this #/bin/mysqld_safe & But when I do that, it says "A process already exists". Am I running it in the wrong place? What am I'm doing wrong? I'm running Fedora Core/CentOS. I realize that I can run these commands: # /etc/init.d/mysqld start # /etc/init.d/mysqld stop # /etc/init.d/mysqld restart However, I want to restart using 'mysqld_safe &' because it restarts as a background process.
View Replies !
Server Not Using Startup Variables When Restarting?
I wanted to change the Max Connections from the default of 100 to 500. To do this I went (using MySQL Administrator) to the Advanced Networking tab under the Startup Variables section. Changed the value of Max Connections to 500 and clicked on Apply Changes. Then to actually apply the changes I went to the Service Control section and restarted the MySQL service. However, after this it doesn't seem to have actually changed, when going to the Health section it still displays a maximum of 100 connections under the Connection Usage. I've checked that the service is using the correct my.ini file (under Configuration File section on Service Control->Configure Service) and also that the my.ini file is updated correctly, that is that under the [mysqld] section there is a line: max_connections=500.
View Replies !
Mysqld Restarting On Remote Connect
I'm on FreeBSD 5.4 with mysql-server-4.1.18_2. Whenever I connect to mysql from a remote client, I get: Mysql error number 2013 lost connection to mysql during query Also, the following is logged: 060506 09:47:25 mysqld restarted 060506 9:47:26 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060506 9:47:26 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 642388. InnoDB: Doing recovery: scanned up to log sequence number 0 642388 InnoDB: Last MySQL binlog file position 0 79, file name ./isd-bin.018710 060506 9:47:26 InnoDB: Flushing modified pages from the buffer pool... 060506 9:47:26 InnoDB: Started; log sequence number 0 642388 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.18-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.18_2 mysql works fine from localhost and I've granted permissions to connect from certain remote hosts. I just don't know why mysql restarts when a remote host tries to connect.
View Replies !
Deadlock Found When Trying To Get Lock, Try Restarting Transaction.
Im getting the following SQLException during an insert or a delete or an update statement. "Deadlock found when trying to get lock; try restarting transaction message from server: lock wait timeout exceeded; try restarting transaction". I have a jsp page which does an insert, i have another jsp page which has a delete query that deletes a particular row, and then tries to insert (using an id,which is a primary key), then there is an update statement. In both these pages, i sometimes get the above mentioned exception. When the Tomcat server is restarted, i do not get the exception.
View Replies !
Lock Wait Timeout Exceeded; Try Restarting Transaction
I have a simple query fired on click of a button. i.e., update table_name set column1='20' , column2='15' where id='1'; Even through the query browser it is giving Lock wait timeout exceeded; try restarting transaction ,this exception. The same was working a couple of days before. what might be the reason for this exception.
View Replies !
Lock Wait Timeout Execeeded: Try Restarting The Transaction
I am using MySQL 5.1.23 and Jboss 4.2.2. My application is trying to update a ta ble. But it is waiting for the lock on the table for more than 200 seconds. I can see that in the processlist table. After that jboss throws CannotAcquireLock Exeception saying timeout exceedded; try restarting the transaction. I have a dedicated schema where no one connected to that schema or querying on that table. Transaction timeout is set to 5 mts in my jboss-service.xml. Anyone knows what is wrong here?
View Replies !
Error : Lock Wait Timeout Exceeded; Try Restarting Transaction
i am trying to create a java application using mysql but if i try to create multiple connections, i keep on getting this exception given below. I have read about the TransactionDeadLockDetectionTimeOut option but i am neither able to find config.ini nor i am running the cluster for which this option applies. Code:
View Replies !
Zero = Blank = Space
how I can change it if possible: mysql> select count(*) from property where number = 0 and number = "" and number = " " and number = " "; +----------+ | count(*) | +----------+ | 43 | +----------+
View Replies !
Non-blank Fields
Is there a way to select all non-blank fields when doing a select statement in SQL? For example, I want to run the query "Select * from <tablename> where username = <username>" The result set contains many columns that are completely blank, as the database I'm working with contains over 100 fields. Is there a way to tell it not to display those blank columns in the result set?
View Replies !
Blank Date Field
How do you determine if a Date field is blank. In my Sql statement I only want records who's date field is blank (i.e. checking for only open invoices where Date_Paid = '' ...still open ...it doesn't work when I use that syntax)
View Replies !
Eliminating Blank Values
I have a database randomly scattered with 'NULL' values, being a newbie to mysql, I was wondering if there was a single command to replace all 'null' values with a string 'no data'. all the fields are set to hold 255 character strings.
View Replies !
Blank Username In Mysql Db
Using a Virtual Private Server -UNIX & Apache 1.3.22 & mysql 3.23.46 I was able to create the mysql root password, however the system will not let me create the admin password (which is supposed to be the same as my account name). When I checked the database to see the current names, this is what I got below: Code:
View Replies !
Mysqlimport For A Blank Database
I have a blank database saved in a mysqldump export file. I have same version of mysql on both machines. I am wanting to just import the blank backup database to the new blank sql server ( no databases or tables on server). I keep getting an error message and it will not allow me to import the blank database. What is my sytax supposed to look like?
View Replies !
Test For A Null Or Blank
Please look at this sql: SELECT name, visual_no, type_aid, aid_topic1, aid_topic2, aid_topic3, length, date_format(when_made, '%m-%d-%y') as when_made, reserved, date_format(res_beg, '%m-%d-%y') as res_beg, date_format(res_end, '%m-%d-%y') as res_end, notes, no_check, check_out, ge.genreid, gen_short_description, sb.subjectid, sub_short_description, specificid, spe_short_description FROM aids ad, tbl_genre ge, tbl_subjects sb, tbl_specific_subject ss WHERE aid_id=1280 AND (aid_topic1 = ge.genreid OR aid_topic1 is null) AND (aid_topic2 = sb.subjectid OR aid_topic2 is null) AND (aid_topic3 = specificid OR aid_topic2 is null) This is for an audio visual library (dvd, vhs, etc.) The database for record 1280 (and many others) contains in the genreid a number (it has data in other words). aid_topic2 and and aid_topic3 are either blank or have the word [NULL] in the field. I am using MySQLCC, if this matters. This SQL brings back a cartesian product. if I just keep the SQL without the ORs it will not bring back a row because there isn't always an equality between the main table and the lookup tables. Sometimes the main table has a row that has no value in the topics and therefore does not equal the lookup table. I did not design the table. I inherited it.
View Replies !
Ignoring Blank Fields
Im having a problem where im allowing the user to identify a row by 1 of 2 unique fields. The problem i have is that my current query states to either take a OR b... so my query looks like this. a = $a OR b = $b Now these unique fields can also contain a result of null. Which means that im returned with more than 1 result when only 1 of the unique fields is entered. Is there a way of escaping results that contain null in either of the fields?
View Replies !
Parent_id: NULL, Blank Or 0
My categories table looks like this: category_id category_name category_parent_id custom_category_name custom_category_parent_id I will be using COALESCE to get the first non NULL value when I query category_name, category_parent_id, custom_category_name and custom_category_parent_id like so: MySQL SELECT category_id, COALESCE(custom_category_name, category_name) AS category_name, COALESCE(custom_category_parent_id, category_parent_id) AS category_parent ... I have set the default value of custom_category_name and custom_category_parent_id to NULL. category_id and category_name will always be present. But what should I set for category_parent_id? Sometimes it won't have a value (when the category is a parent category) and sometimes it will have a value. Should I set category_parent_id's default value as NULL or 0 or blank?
View Replies !
Blank Columns Or Separate Tables
I have a form with 8 fields, 4 of which are required and 4 are not. Usually if a field isn't required I would create a separate table for it rather than having a blank value in the table where required values would go. In this case, I'm not sure if I should put all the not required fields in one table or separate tables. Since any one of them can be or not be blank. I'm trying to find a balance between normalization and practicality for the database, as well as programming. So, are columns with blank values acceptable to a certain number? Are 4 separate tables too many, so that there aren't any blanks in a column if they were in one table?
View Replies !
Removing Blank Tabs In Rows
Some of my earlier rows (Database is about 360mb) have blank tabs between text, i can I modify each row and delete the tabs so the size is smaller? I searched php manual didn't find a helpful function, maybe someone else has done this?
View Replies !
Passwords, Permissions, And Blank Users
I have Apache 2 server, PHP5, and the latest MySQL installed on my system. I'm currently reading PHP and MySQL for Dummies (I told you I was a newbie) and trying to work through a few of the examples.One thing I noticed when I looked at the "users" table in the "mysql" database is a blank user with all privileges on localhost. I deleted that entry, set a password for my "root" account, and created another account with a non-blank password. The problem I am having is that I am trying to connect to the database as "root" with a blank password, and it's still working. I then tried a blank user, and it worked. I tried a random assortment of letters and numbers, and it worked.
View Replies !
Mysql_connect() Returns A Blank Page
I already installed Apache 2.0, PHP 5, MySQL 4.0 on my local machine. The php and apache are already set and it can process php scripts without problems. On the other hand, i can access my MySQL database, create table and others using the MySQL Monitor or the MySQL Manager. Now, i will try to connect to my database; my problem is, the php script that has the mysql_connect() returns a blank page. Here's the code: ......
View Replies !
Statement Results In Blank Page
I'm constructing a blog for my site. After I got nowhere trying to automatically configure dd-mm-yyyy dates on the fly, I decided just to write the dates manually and order the posts by automatically incremented id instead. However, in constructing my monthly archive pages I've come up against a problem. Here is the PHP I'm using to get the info from the database: $blog = mysql_query ("SELECT title, content, date FROM blog WHERE date IN ('August 2005') ORDER BY id DESC LIMIT 10") or die(mysql_error()); The date column in my table is VARCHAR and all the entries so far contain the characters August 2005 but all I get is a blank page. I'm using this while loop to display the results: while ($entry = mysql_fetch_array($blog)){ echo ' <p class="blogdate"> '. $entry['date'] .' </p> <h2>'. $entry['title'] .'</h2> <div class="blog"> '. $entry['content'] .' </div> '; }
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 !
Saving Storage Space On Blank Entries In DB
If I have a table, of say.... people, with their names, ages, addresses etc., and some lines in the table have the ages BLANK, how do I make sure that the blank fields are not taking up disk space? Does OPTIMIZE TABLE do this, or is another command?
View Replies !
PHP Script Inserting Blank Text Into MYSQL
Have been following a tutorial which has following line in PHP script to write text form Flash form into an MYSQL DB and then redisplay it back in the form Relevant code is: $Connect = mysql_connect($DBhost, $DBuser, $DBpass) or die("News=Uh Oh, Could not connect"); mysql_select_db($DBName, $Connect); $result = mysql_query("INSERT INTO $table (UserName, News, TimeAdd) VALUES ('$UserName', '$EnterNews', '$Today')", $Connect); Print "Status=News has been added"; When I execute this web file only the $Today string is updated correctly into DB. $UserName & $EnterNews which are text fields from the flash form are blank/null entries into MYSQL DB If I manually change data in field via MYSQL console each field is displayed correctly so my read script seems to work. Can anyone point me in correct direction to solve this one. Is it the way I have connected to MYSQL or should I be looking closer at the flash form.
View Replies !
How To Change Cell Values From NULL To BLANK?
In the result of a SELECT statement, how can you change cell values from NULL to BLANK? The following does NOT do it: SET fieldname = ' ' WHERE fieldname IS NULL Also, for colums with a DATE data type, I want to change 0000-00-00 to BLANK. For for colums with a numeric data type such as DOUBLE, I want to change 00.00 to BLANK. Again, the above doesn't work. How can I blank those fields?
View Replies !
Multiplication Statement Returns Blank Results
I am atmysqlting to write a MYSQL statement that multiplies two different column values (price x time_rate) and displays the new value in a "completion_rate" column. All the values display correctly except for the blank value in the "completion_rate" column. INPUT SELECT quote.quoteid, quote.size, rate.size, rate.price, timeframe.time_rate, rate.price*timeframe.time_rate AS completion_rate FROM quote, rate, timeframe WHERE quoteid = #URL.quoteid# AND rate.size = quote.size AND quote.completion = timeframe.time_range OUTPUT quoteid size size price time-rate completion_rate ------- ---- ---- ----- --------- --------------- 10 18x20 18x20 1710.00 0.50
View Replies !
Blank Page When Attempting To SELECT Data
We're storing data in a mySQL database via a php script. For some reason, every week or so (depending on how many connections were making) my PHP scripts just quit working. Restarting mySQL resolves the problem. I've checked to make sure that all of the scripts are closing the database after posting/selecting the data. Any other suggestions on why this might be occuring?
View Replies !
What Field Type To Use To Avoid Blank Spaces In Fields
Can you tell me the best field type to use here? I've got a table in mysql with all 5 fields defined as tinytext Problem is when I export this to to a text file for notepad each field is padded out by several blank spaces, and i think my eamil program doesnt like this type of structue : field1 , field2 , field3 , field4
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 !
Service ID?
I have recently installed MySQL on a Red Hat box. My previous DB experience has been with SQL Server on a windows machine. On Windows SQL Server runs under a user ID. Does MySQL run under its own ID? If so, how do I determine which ID it is currently running under and how would I go about changing it?
View Replies !
|
TRACKER
