DOS Window Beeps And Closes After Entering Password
I am running MYSQL on the command line and it is working fine and continues to work until I shut down my computer. However, when I start up my computer and bring up the command line and enter my password, it beeps and closes. The only solution I have found is running a "repair" routine. Does anyone know why this happens and if it can be avoided?
View Complete Forum Thread with Replies
Related Forum Messages:
DOS Window
Installed Community MySQL on XP. Everything runs fine, but when I shut down PC and then start up, I invoke the command line, enter my password, and the window shuts down. I need to reinstall MySQL each time.Why does this happen, and how can I resolve?
View Replies !
Entering Datas
I done a little bit of sql a while back and now I need to start up again. I have got to grip with most of the commands again and managed to create tables etc. One thing I can't remember how to do or find on the web is how to read from a text file. I have a text file with a load of sql command in it and data to populate my tables etc but I thought there was a command which basically says run this file. something like open "myfile.sql"
View Replies !
Entering Information
I have looked threw many books and the nety but cant find how I would enter more attributes into a table that already exists in a database in MySql All I seem to find is for to insert values into a table.
View Replies !
Entering New Data
Let's say I have this: Code: $save_entry= mysql_query("INSERT INTO clients (Name, Telephone, Email) VALUES ('$name','$telephone','$email')") or die(mysql_error()); What if I want to EDIT this data (through an online form), how do I save the changes (let's say the name can't be changed but the phone number and the email can) to the existing data that is already in the database, without creating a new entry. Something like this makes sense to me, but that's not correct syntax according to MYSQL. Code: $save_entry= mysql_query("INSERT INTO clients WHERE Name = '$name' (Name, Telephone, Email) VALUES ('$name','$telephone','$email')") or die(mysql_error());
View Replies !
Entering And Recalling
I have been running my site forever with just regular html, and I want to make a page where I can enter a title, a date, and then the content, and then I want to be able to display each entry on seprate pages.
View Replies !
MySQL DOS Window
When I type in the "create table" command in a DOS window there are a lot columns and eventually I am not able to type in the command into the DOS window anymore. It appears that there is a character limit in DOS, and I run out of room and am not able to finish typing the complete "create table" command. How can I finish typing the complete "create table" command into the DOS window? Short commands are no problem as long as they don't exceed the character limit. I need to set the allowed characters from the command line to a higher number some how. If this is possible?
View Replies !
Target To New Window
how to setup a little table that includes links to a file image and to its URL. Its a table of NFL cheerleaders that takes you to there website each week. Its designed to automatically change the picture and url on my website when I update the week. Well, I have a query that grabs the image and url as follows, and it works just fine. But what I want this to do is that when you hit the link, it opens the website up in a new window. Here's the code I have: $query = "SELECT week_index.latest_week, cheerleaders.week, cheerleaders.cheerleader, cheerleaders.image, cheerleaders.url FROM week_index, cheerleaders WHERE week_index.latest_week = cheerleaders.week"; $result = mysql_query($query) or die('Can not execute query.'); while($arr = mysql_fetch_array($result)) { $imageurl = $arr['image']; $thumburl = $arr['url']; print "<a href="$thumburl"><img src="$imageurl" width=125 height=187></a>"; } I'm not sure how to include the target=blank in there.
View Replies !
Entering A Date Into Mysql
I'm creating (still, this has been going on for some time now) a web based scuba dive log database and of course I'd like to enter the date that the dive took place. I understand that mysql stores the date information in the YYYY-MM-DD and if I use lets say phpmyadmin to enter the data for the dive and of course use the above format to enter the date everything is great. But when I start getting the web side of things going I don't want to have to enter it in that format but rather the 'usual way' of MM-DD-YYYY How do I accomplish this ? This might be better posted in the PHP forum but thought I'd start here first. PHP/MySQL along with CSS and xhtml are the languages.
View Replies !
Entering Japanese Characters
Edit: Inserting it into the database manually works, so its entirely possible this is just a problem with php reading it and inserting it wrong. I'm just going to post this in the php section,
View Replies !
Entering Recurring Events
I have a events table with a date column and I was wondering if there is a way of inserting recurring events (monthly, weekly) without having to enter each event on its own.
View Replies !
Addslashes And Entering Data
I am trying to enter last names into my mysql database. I used addslashes before entering the data to the table $last = addslashes($_POST['last']); Trying to have some protection against sql injection I think. Here's my problem. When I enter the name O'Reilly it puts in O'Reilly. When I display the last names how do I drop the so I can see O'Reilly instead of O'Reilly. Also do I even need addslashes?
View Replies !
Entering Session Details
I want to get the session details (username) of a person loged in. And want that details to be entered to a separate table in he same data base. how can i do that. A coding for that would e perfect.
View Replies !
Temporal Window To Do Calculations
i am trying to find a way to average my data for a kind of "sliding window" but could not find a way yet to do so. my table looks like this: id|data|time 1 - 23 - 46 1 - 25 - 56 1 - 12 - 69 1 - 6 - 86 1 - 17 - 105 1 - 16 - 121 1 - 21 - 141 1 - 35 - 163 1 - 24 - 189 : : : 4 - 21 - 68 4 - 12 - 78 4 - 32 - 112 4 - 23 - 135 : : : time is a timer in seconds. what i would like to do is to build a kind of sliding window of 60 seconds. starting at min(time) of each id, 46+60 = 106; so avg(data) for id=1 unti time= 105. than for 106+60 = 166, avg(data) for id=1 until time=163 and so on. the same for all id's.
View Replies !
Entering Data Into A Bridge Table
To make a simple music database, I've made a table of songs and a table of players joined by a bridge table (song_play) to allow many-to-many relationships...eg: create table song (song_id int primary key, name char(30)); create table player (player_id int primary key, name char(30)); create table song_play (song_id int not null, player_id int not null, primary key(song_id, player_id)); Once the names of songs and players are entered into their respective tables, is there an easier way to enter data into the join table other than looking up the id's from song and player and entering those into song_play?
View Replies !
Entering Dynamic Values Into Rows?
Is it possible when entering values into a table, to enter a string value from one column into another column in the same row in the same insert command? Is it possible in the insert command, to call some predefined function to get the appropriate value for the 3rd column? In calling this function, i would use the value from the 2nd column as the argument. this (theoretically), could look somthing like this: INSERT into IMAGES values (NULL, 'images/image_01.jpg', 'func(col2.value)'); the function would be somthing like: (excuse syntax, i haven't learned MySQL functions yet, but just to give an idea) function func(string s) { select str = s select str = SELECT REPLACE(str, '.jpg', ''); select str = SELECT SUBSTRING(str, 8); return str; } The resulting inputted values would then be: (NULL, 'images/image_01.jpg', 'image_01'); If this were possible, it would save me a LOT of uneccesary typing, as for each insert command, i'd only have to change the path name for col 2 and not type the name for col 3.
View Replies !
Entering Data Into Db With Hard Returns
I have a html textarea where user submit text and it gets stored in a db. For example: This is a test. Here is my list... one two three See, the text has hard returns in it, but when i output it back on the page with php, it all goes into a continuous line. How can i have the hard returns in the output. Like I have the '' included.
View Replies !
Sliding Window Over A Large Dataset
Given: A really big table whose contents I want to view by "lazyloading" parts of it at a time. The entire database is too big to load all at once. Requirements: My UI is a window that shows ten records at a time. It pages up and down. Initialy it loads with the first ten entries. I push page down and the next ten show up. I can back up and look at the previous ten. Right now, I'm just shooting for readonly access. So what SQL technology is a good fit? A cursor seems like a good fit because it can go backwards and forwards, though I've read that there are scalability concerns.
View Replies !
Window With The Mysql> Stay Open
I have installed PHP MySQL and Apache on my system with the intention of using it to run my website with a database. I have managed to get PHP and Apache working fine but to date have not been able to get MySQL to work. When entering a command in the Windows XP prompt I get a window flash on the screen for a second and then it is lost. How do I get this window with the mysql> prompt to stay open on the screen. Look forward to help with this as I am now contemplating abandoning the whole setup and reverting to using the Windows IIS instead.
View Replies !
Window XP OS: Netbeans To MySQL Connection
i using NetBeans 5.0 to connect to MySQL 5.0 database. the connection can work in the server computer but cannot work if i use different computer to connect. how to i set for remote connection.? at my.MainMenu.ConfigureSourceDBConnection.init ConfigureSourceDBConnection.java:30) at my.MainMenu.ConfigureSource.<init>(ConfigureSource.java:24) at my.MainMenu.PAManager.ConSourceActionPerformed(PAManager.java:269) at my.MainMenu.PAManager.access$200(PAManager.java:13) at my.MainMenu.PAManager$3.actionPerformed(PAManager.java:74)
View Replies !
MySql Admin :: Window Always Appear On The Desktop
When I boot my computer the MySql Admin window appears on the desktop. The only way I can close it is my clicking the Hide 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.
View Replies !
Syntax Error On Entering Tables Into Database
As a total newbie, got a problem. I was supplied with a set of tables for a database to enter/import. On doing so, the phpmyadmin returns the following error message: MySQL said: #1064 - 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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=106' at line 17 .....
View Replies !
Making A Mistake When Entering Mysql Command
Just wondering I'm going through the book "build your own database driven website using mysql and php. While I was typing in a joke to enter into the database I messed up and don't know how to fix it mysql>INSERT INTO joke SET ->joketext = "This is the joke I was entering", ->jokedate = 2004-03- 02"; ->; ->c; ->/c; As you can see I tried to get out of it but didn't know what to use so I just closed the command promp screen and began again. There has to be a better way.
View Replies !
Entering Form Data Into Multiple Tables
I've got a two tables in my database: "customers" and "orders." I want to insert information from a form into both of them - in some cases identical information will need to be inserted into both. The other twist is that I'd like to insert the automatically generated id customer 'id' value into the orders table. I've tried using joins. Something like: PHP Code: INSERT INTO orders,customers (customers.id, customers.first_name, orders.del_address   .....)
View Replies !
Command Line Client Window Width
when using MySQL the width of the window can only be dragged to a width of only less than half the width of my screen. Is this normal? Why cant the window be expanded to fill the screen like almost all other applications?
View Replies !
MySQL (PHPTriad Download) Window Wont Display.
Have downloaded the PHP Triad software from SourceForge.net as have had problems getting Apache working after installing from the Apache.org site. Apache works using this version but when selecting the MySQL - D from the start menu, the pop-up window doesn't display, but it flashes on then off. There is no uninstall option, and this isn't displayed in the windows remove programs setting either. How can I remove and reinstall, or get this working?
View Replies !
Mysql Data Soruce Name Setup Dialog Window
my program connects remote database with ado. i change ado settings in runtime. when ado doesnt connect remote database, "mysql data soruce name setup dialog" window comes to screen. i want to change host when connection failure.
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 !
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 !
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 !
Password :: Change Password
I have trixbox 1.2.3 running and in freePBX it told me I need to change the password in mysql. I went into mysqladmin and privileges. I updated the passwords for a2billinguser and root. Now I am denied from access to mysql and all services that use mysql don't work. How do I restore the default that trixbox used. I have a very large major system here and cannot just blow it away.
View Replies !
No Password
When I'm trying to access a database, MySql answer that my access is denied for user root@localhost . For database ... When I'm going in the users section of PhpMyAdmin, It said: No user (s) found What can I do, is there a manual way of adding user/password ???
View Replies !
Password Set Up
I am trying to install MySQL Essential 4.1. on Windows ME and it will not let me set up a password. I have installed it on Windows 2000 before and it took me through several dialog boxes setting up a password. On Windows ME it already seems to have set up a password and kicks me out when I try running MySQL. Do I need to be connected to the Internet when Installing? Is there a difference installing on Windows ME.
View Replies !
Password?
I have installed MySql 4.1 on Windows XP (not as a service, manual start), but when I try to access the Command Line Client it asks me for a password and I have no idea what it is.
View Replies !
Getting A Password
I am trying to figure out how to get a password for a sql on my forums... My host provides where it installs the forums and just generates the sql stuff... Is there a way for me to figure out how to get the password?
View Replies !
Using Password: YES
I installed on my laptop MySql Server in Windows, and I've a problem login in with a simple user. With user root, it works ok, but when I try to coonnect with other user, I always obtaint the error message "using passowrd: YES" (MySQL error 1045). If I try to connect via command line with "mysql -u user" without indicating a password, it works ok, but if I try with "mysql -u user -p", when I enter the password, I have the error. If I tried to connect from MySqlAdministrator or QueryBrowser I have the same issue if I write the password, and a good connect without password.
View Replies !
How Do You Set A Password?
I entered in "set password for 'wikiuser'@'localhost'=password("password")" but it says it couldn't find any matching rows. But there is a row with that host and user. Also, there IS a password in the row, but when I try to install mediawiki, it says check username and password.
View Replies !
Having A Password
I want to be able to hold a password in my table in some kind of secure way. I have tried to insert a user record into a table using md5() for the password which is inserted in the database like this... insert into users values('', 'sim0rsy', md5('banana'), 'Matt', 'Munn', 'Student'); this is the query that I think should work but it doesnt, what am i missing? select * from users where username='sim0rsy' and password='banana';
View Replies !
|
TRACKER
