Standard Way To Store User Information
I have a database for storing user information. Is it standard practice to create a new table for each user's data, or have one huge table with everyone's data?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
4.0.14 Standard Creating User Issues
We just installed mysql 4.0.14 on an xserve. When trying to add users via mascon I'm finding an issue I have not seen in previously releases. When adding a user it seems that the new column ssl_cipher is a required field. I know this is new for v4 but is it supposed to be a required field? What should the default be? I can't modify any user without being notified that it is required.
View Replies !
View Related
Trying To Revoke User Privs Cpanel Phpmyadmin Mysql 4.1.21-standard
I have created a user (someone). Logged into cpanel as the main account if I try .... REVOKE ALL PRIVILEGES , GRANT OPTION from someone@localhost; I get"#1044 - Access denied for user 'myaccount'@'localhost' to database 'mysql'" Can anybody tell me if there is anything I can do / another way to accompish the creation of a new user but only allow them access to certain priviliges? e.g. I don't want them to be able to drop tables. If I do this - there is also an error...... GRANT DELETE , INSERT , SELECT, UPDATE ON myaccount_thedb.table_1 TO someone@localhost; ""SELECT,INSERT,UP command denied to user 'myaccount'@'localhost' for table 'table_1'"" Also updateing the user privs in cpanel gives no errors but does not work.
View Replies !
View Related
User Information Changed
The other day someone changed every user's password on my site. Then they changed every user's email address to theirs - I assume the reason was that when the user used the password reset function, they would never see the information. I'm trying to research what/where the vulnerability is in the script that I'm suing, but I don't really know where to start - not being a hacker, I don't even know the terms to search for here or on google. Is this what is meant by mysql injection?
View Replies !
View Related
Merge Table To Share User Information
I run two different forums and I'm not sure on how to have both forums share the username, posts, and other user information. Each forum has their own database and I'd like to know if there was a way to merge the user tables instead of all the tables from the database.
View Replies !
View Related
Error In MySQL Administrator When I Try To Change The User Information
I recently install the MySQL 4.1.8-nt-max, and the MySQL Administrator, but when i try to change the information (name, description, email, etc.) in the Administrator I get the following error: " Invalid UTF-8 Error executing query (illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation '=' " Before it happens the Administrator crash down ... Im from Mexico, so my Windows XP regional configurations are spanish / latinamerican. Any ideas about it?
View Replies !
View Related
Standard Sql
i wanted to know if there is a standard way of limiting results in sql i've seen this page, and it seems there isn't http://dotnet.org.za/thea/archive/2005/02/22/14715.aspx just wanted that confirmed personally i like mysql's limit as it allows for offsets, and is nicely placed at the end of the query (but it obviously doesn't work for other db server's)
View Replies !
View Related
Learn Sql Standard
I'm just learning mysql--having no db experience. I'm wondering if my-sql-specific commands overlap with sql standard commands. I noticed when reading the mysql manual, that one of the user comments on the bottom of the page says that the "describe table" and "show tables" are mysql-specific. I also noticed that they use the non-standard "load data" command, where "insert" is the standard. I was under the impression that mysql-specific stuff was just an extension of the sql-standard, not an alternative. Are there a lot of overlaps like this? If so, do you recommend any other sites besides the mysql where I could learn the standard commands first?
View Replies !
View Related
Standard Deviation
I have Shows listed in a database (ShowID) and each show has several user ratings which are in a varchar field in the database called ‘rating’ which simply lists one of the verbal ratings: Highly Recommended Recommended Somewhat Recommended Not Recommended My problem is that I would like to convert each rating to a scale from 4 to 1 (Highly Recommended = 4, Recommended = 3, Somewhat Recommended =2, Not Recommended = 1) and then get the Standard Deviation of that list of numbers for each ShowID. Is that possible?
View Replies !
View Related
Database From 4.0.22-standard Into 3.23.58
If I have a backup of a Database created on MySQL 4.0.22-standard version (in a .SQL queries, that will re-create the tables and insert the data into them), and I changed server, and the MySQL version they use is 3.23.58, is it compatible, can I use the same backup queries ? (It uses the CREATE TABLE syntax and the INSERT INTO syntax.)
View Replies !
View Related
Last Id MySQL 4.1.21-standard-log
we have a very busy database server, and alot of insert is going on in it. but my program requires to get the last_inset_id. i did this using PHP mysql_insert_id(). now the problem is since there are alot of insert, i believe that mysql_insert_id() is getting the wrong id thus i am having duplicate id's in my other table. so linking my two tables through id is screwed up. id is auto_increment btw. can i specify the last_insert_id to only look at a specific database.table?
View Replies !
View Related
Downgrade V5 To 4.0.25-Standard?
I am in desperate need of being able to downgrade a MySQL v5 database to MySQL4.0.25-standard. vBulletin and my hosting said they can not do it with out loosing auto-incramnet and other variables, but my former hsoting was able to downgrade for me. Is the a program or tool I can use to downgrade while keeping everything intact?
View Replies !
View Related
Does MySQL (4.0.20-standard) Allow Subqueries
Im moving a development app (MySQL 5.0) to a different server which runs MySQL 4.0.20-standard. I am getting errors on queries that have subqueries such as... SELECT id FROM table1 WHERE id IN ( SELECT id FROM table1 ) Seems like such a simple query but it wont run? Anybody know the answer and what other limitations im going to experience going from version 5.0 down to 4.0.20-standard.
View Replies !
View Related
Does MySQL (4.0.20-standard) Allow Subqueries???
Im moving a development app (MySQL 5.0) to a different server which runs MySQL 4.0.20-standard. I am getting errors on queries that have subqueries such as... SELECT id FROM table1 WHERE id IN ( SELECT id FROM table1 ) Seems like such a simple query but it wont run? Anybody know the answer and what other limitations im going to experience going from version 5.0 down to 4.0.20-standard.
View Replies !
View Related
Any Way To Dump From Mysql 5.0 To 4.1.22-standard?
I have a MySQL 5.0 database that I have dumped to a flat file with: mysqldump -u username -p databasename > mydatabase.sql I have written a cgi perl script to import the dumpfile into a new table in an existing database. The script runs fine when I run it on the local host. But when I upload the same script and dumpfile onto a webserver that is running MySQL 4.1.22-standard, I get the following error when trying to import: DBD::mysql::st execute failed: 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 '; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101' at line 7 at mysqlimport.cgi line 24, <FH> chunk 1. I would have thought that a dumpfile would not be version dependent, but apparently it is. The database is very simple. - Is there any way to edit it so that it will import into the lower rev db? - Or is there a way to dump it into a lower rev format? - Or is there some other solution (other than upgrading the server)?
View Replies !
View Related
Syntax Differences Between V. 4.0.23-standard And V.4.1.10
Basically i'm having trouble getting this to run on V. 4.0.23-standard, it runs fine on V.4.1.10. UPDATE leads SET keywordClicks = ( SELECT keywordClicks FROM googleinfo WHERE googleinfo.keyword = leads.refererKeyWords ) WHERE EXISTS ( SELECT keyword FROM googleinfo WHERE googleinfo.keyword = leads.refererKeyWords ) Is there any glaring syntac differences between the version, and if so is there a resource that documents them?
View Replies !
View Related
Standard DATE_FORMAT Query
I have a standard DATE_FORMAT query, for example: $query = "SELECT DATE_FORMAT(someDate, '%a, %b %e, %Y') AS someDate FROM table ORDER BY someDate"; My problem is that I need to nest another query within this one that has a WHERE clause based on the date: $anotherQuery = "SELECT * FROM someTable WHERE theDate = '$row[someDate]'"; Due to the odd formatting of the date in the previous query, this query doesn't return any valid results. I'm very new to these operations. Is there a way to format the date AND keep the proper mysql formatting? Any help is appreciated.
View Replies !
View Related
MySQL Version 4.1.21-standard Log In Help!
I am using phpmyadmin through my web host provider. I have set up my database and username with a password. I open phpmyadmin, open the SQL query window and try to log in with this mysql -h localhost -u myusername -p When I submit, I get this error: Error SQL query: mysql - h localhost - u myusername - p MySQL said: Documentation #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 'mysql -h localhost -u myusername -p' at line 1
View Replies !
View Related
Difference Between Standard And Community Releases
I was wondering if somebody could tell me what the differences are between the Standard and Community releases, or point me to where the documentation is. I am looking for rpms for RHEL 4 x86_64. I require release 5.0.22 or greater and can only find community releases on the download page. MySQL-devel-standard MySQL-shared-standard MySQL-server-standard
View Replies !
View Related
Port 3306 Unless Standard Configuration
I've been trying figure out this problem for a while. Port 3306 won't forward unless I have standard configuration server installed when I'm trying to make a Detailed Configuration. That means port 3306 only opens up (yes I port forwarded and my ISP does not block 3306) when Standard Configuration is choosen.
View Replies !
View Related
Help With MYSQL And PHPBB On Server 2003 Standard
Trying to get help with this situation. I have installed PHPBB, PHP (4X) and MySQL 4.1. This is how I started out. 1. Installed MYSQL - ran setup - did FULL install - and entered in new password when requested. MYSQL gave the green light when computer rebooted. Created new database with CREATE DATABASE XXX; Also installed ODBC from MYSQL site and created a "SITE DSN" for the ODBC 2. Installed PHP and verfied working and accessible 3. Installed PHPBB per the instructions on the site. Did the permissions as instructed on config.php and install.php 4. Came to the install screen. Entered the info and password that I did with MYSQL installation (Root was the username) NOW SAYS - CANNOT CONNECT TO THE DATABASE. I do not know what to do at this point.
View Replies !
View Related
Standard Char Length For Storing URLs?
I'm curious as to what the standard char length is when storing URLs into a database. Im sure 255 is way more than enough, but is that the safest bet? In my particuliar case the admin will be adding links possibly some generated from site such as yousendit or sendspace, but even those links seem to max at around 128 characters.
View Replies !
View Related
Replace Information In One Table With Information From Another Table
I've got two tables in one DB they have various columns; what I need to know is how I can take the information from a column in one table and put it in to a column in another table. table1 - characters table2 - characters_jackedup I want to take the information from column maxMp in table1 and put the information in table2 under maxMp the column exists in both; but the columns are in a different order.
View Replies !
View Related
Error 1142 - Mes. The Following Occured: SELECT Command Denied To User Xx@hostx.com For Table 'user
When trying to do anything to do with "User Administration" in MySQL Administrator 5.1 connecting to a remote MySQL database, I get the following message when I click on the "User Administration" icon/text in top left frame. Verbatim quote apart from my connection details which I am anonymising): A MySQL error was encountered. The message is: Could not fetch user names. The following occured: SELECT command denied to user xxx@hostxxx.xxx.xxx.com for table 'user' (1142) No I have looked through search and found the following: http://lists.mysql.com/mysql/134369 Unfortunately that tells me that it has happened to someone else but that's about it. What is one supposed to do with the fix? I am wondering if this is why I cannot create ordrop any tables with this username at the moment, even though it is the Admin level username....
View Replies !
View Related
Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database. I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.
View Replies !
View Related
Mysql Information
My company is currently investigating in several database, projects tracking software. Being a beginner, I would like to know if you could provide me some support concerning the capabilities of MYSQL. We are looking in a software that could achieve the following: - Enter text related to specific subjects (text can be pretty long and should be searchable by key words) - linking tables and extract specific information from those tables (no problem with that). - The ability to assign author privileges and to change them easily) - The ability to assign task to some users. - the ability to access the database and modify the information on the web. - the ability to automatically send the information by email or at least notify one of the user that a project has been updated. - the ability to point at other document (word, pdf etc) and to easily access those documents from the database.
View Replies !
View Related
Select Information
my current sql query is SELECT * FROM entries WHERE approved='1' ORDER BY rating DESC,hits DESC,votes DESC which works. but i want to implement multiple pages to my site. so i only want it to return for instance the first 15 rows, or only row 16-30 or only 31-45 etc
View Replies !
View Related
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 !
View Related
Group Information
I have a database with a date field in it, and I am trying to figure out how I can pull information for a calendar week at a time.I am sure that some type of loop is needed, but I am stuck trying to figure out the logic.
View Replies !
View Related
Most Common Information In DB
I have a database with the following fields id, system, reviewer an example would be 0, 5, 9 1, 5, 9 2, 4, 9 is there a way that i can search for all of reviewer 9's reviews, and find out what system is reviewed the most...?? so reviewer 9, it would be system 5 according to the example above.
View Replies !
View Related
Selecting Information
I need to select fields from one column, but this column contains duplicates on many rows. How do I write a query that only selects the info once and ignore it if it exists again.Pretty much I want to build an optionbox with every field from this column that is different. Since some fields in this column have the same value I don't want to list it twice so the standard SELECT all will not work.
View Replies !
View Related
Sortting Information
Here is a makeshift page I have made for sorting information regarding some car's and their respective times in drag racing. http://www.1320video.com/times.php As you may notice, when sorting some columns in a ASC to DESC fashion, it places the zero's before everything else. Without actually not selecting the rows with 0's in the SQL statement, is there a way to sort these so they show at the end?
View Replies !
View Related
Retrieving Information As It Is
I have a mulitline input field, going to a database, when i view the inputted information in the database "browse" i looks exactly like it does when i typed it in for example Line one Line Two When i get the information back out using a SQL statement it come out in one lone line thus Line one Line two, with two boxes in between where the line break should be. I need to to come out as it went in Is this possible?
View Replies !
View Related
Get Information About An Error
I'm running MySQL 5.0.48 and would like to be able to retrieve an error number or error message when an error has occurred. I know that I can do: SELECT @@ERROR_COUNT; But since I mostly know that an error has occurred that is of little use to me. When connected to MySQL I can do things like: SHOW ERRORS; SHOW WARNINGS; But I can not do a SELECT so that is not of much use either. The reason I want to do this is to log errors that occur in a Stored Procedure.
View Replies !
View Related
Find Row With Most Information
Is it possbile to find select the row of a table, which holds the most information, via a SQL query ? E.g. there are 3 rows, in 2 of them are only 3 fields filled with data, the 3rd row contains data in all x rows, so this row holds the most information. Is it possible to do that generic, so without checking each specific column in the query?
View Replies !
View Related
Transfering Information Between 2 Different DBs
i have an old DB done for a forum in the mambo system ( now called joomla ), but i am changing now to vbulletin system + vbadvanced. The DB i use is MySQL in both forums, but when i open the backup file from mambo and compare it to the vbulleting DB using my phpdev system, i see that they are tottally different. would you have any tip for me so i can save at least my users and their information from mambo to vbulletin? Can someone help me? It´s a very seriou forum, it´s from Alias ( 3D Maya Software productor), and so, could please somebody give me a tip? A help? A force to make me win my MySQL battle?
View Replies !
View Related
Fetching Information
an example: $dbl->query($query); $res = $dbl->get_result(); how do i pull information from a row in $res without automatically moving the pointer ahead.with: $myrow = $res->fetch_array() i pull the correct information but i don't want the pointer to move ahead in $res.
View Replies !
View Related
Sql Headers Information
I have a scSi disk 36.4GB, I lost information from it and tried to recover with other recovery softwares to no avail finally I got winhex & got the professional licence. I can now be able to see all the information on the 1 whole NTFS partition, but the problem is that I can't be able to recover it. whenever I open the logical drive I can see all the information and most of the information is stack up in a "free space" which is around 33gb which I can be able to see has all the information that I need. I have tried to recover the free space but its only copied to the location that I specify and no recoveries are made. recovering the files by type/ name has bore no fruits. A freind told me I have to curve out that area and use data extractors to get the information out of that area (freee space). The information in that drive are sql data bases and zip files. whats the header for sql. what techniques do I use to curve out that space and be abele to extract the information, for I can even read the information in text format. which are the data extractors available in the market.
View Replies !
View Related
Passing Information
I'm having trouble passing an item from a text box to another screen. Whenever I enter an address into the box like 123 First St. the only thing that gets passed is the 123 on the URL. Because of the %20 spaces it cuts it off. How do I remedy that?
View Replies !
View Related
Displaying Information
I have inserted all of my information into my data base. Now I want to print it onto my website. I know how to get it to print onto my website, but I don't know how to organize it. I want to print the information into an table, and I want the table rows to alternate colors. Also I want to adjust font, how would I do this?
View Replies !
View Related
|
TRACKER
