Setting Up A MySQL Db
how's it done? I have only ventured as far a local Access type db up until now, but I now need a db "out there" that can store info submitted from a form on one of my websites. I have recently been experimenting with phpBB as a piece of open-source (free) software that taps into MySQL on my webspace, and seems to take almost all the hard work out of setting up a complex forum.
It there some software that will do a similar job for me with a db? And can such a db download its data to a local db, like Access?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
Setting Up MySQL
I set up MySQL, obviously not right. When I attempt to use the command: mysql -u root -p I am then asked to type in my password. I do that and then ERROR 2013 (HY000): Lost connection to MySQL server during query. I run Win XP and Norton Internet Security.
Setting Up MySQL
I tried removing MySQL But when asked for my password it would let me type it & Im log in as admin. Please Help ASAP I need a MySQL Project done. here is the terminal line: [flash-AlPB-1GHz:/usr/local] chadelso% [flash-AlPB-1GHz:/usr/local] chadelso% cd /usr/local/mysql [flash-AlPB-1GHz:/usr/local/mysql] chadelso% cd /usr/local sudo rm mysql sudo rm -rf mysql-3.23.47-apple-darwin5.1-p [flash-AlPB-1GHz:/usr/local] chadelso% sudo rm mysql Password:
Setting Up MySQL
This is how the server is started: mysqlinmysqld --defaults-file=mysqlinmy.cnf --standalone --console There's no "--old-passwords" but it's still not working. I have Xampp, btw. In my.cnf I took out the "old_passwords" declaration. I restarted the server a few times and it's still not working.
Setting Up MySQL
Little 333 machine with Kubuntu Linux loaded and running fine for over a year. Grabbed Mysql 4.01 and MySqlAdministrator via Synaptic Package Manager. (yeah, I know - don't expect great performance - it is just my daughter's old former Win Me machine hat Linux has breathed a little new life into....) Question: Looks like all I have is a command line interface to MySql at the moment. What must I do to define a database,username and password so that I can use the nice Admin GUI tool? It wants a server host name, user name and password, so I gather there is some set up work to be done from the Linux command line before I can proceed.
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?
Setting Up MYsqL>
how would i install and set up mysql so i can run some forums off it using apache2?
Setting Up Mysql 5
i've installed mySql 5 on my windows pc, also with it i've installed PHPMyAdmin! this works great but at index page when loading phpmyadmin it states that my root password is blank...so i've ran the following script so i can update the 'root' password: CODE update users set password=PASSWORD['mynewpassword'] where user = 'root'
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??
Setting Mysql Password
How do I set the mysql password? Are there separate password for every database I create?
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?
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.
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.
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' .
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.
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 .
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
Setting A Mysql Field
say i have the field armour i want setting to equal max_armour, how exactly would i go about that?
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.
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?
Setting Mysql Root Password
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:
Setting Up MySQL With PhpMyAdmin On WinXP
Installed Apache, PHP, and MySQL on a XP box. Everything seems to work fine but phpMyAdmin is not able to login to MySQL. I use root as the username and the password entered during install of MySQL and what is in the phpMyAdmin config.inc.php but I keep getting access denied! I've uninstalled and re-installed twice now and still having the same issues. apache 1.3.33 php 4.3.10 MySQL 4.1.9 phpMyAdmin 2.6.1
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?
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).
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.
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:
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?
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?
Setting Up Mysql On Fedora Core 4
I have Fedora Core 4 installed in my server. I want to setup mysql and the steps I took is as follows (I login as root) I 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 Code:
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)
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.
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?
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.
ASP & MySQL - Setting Up A Central User Repository [?]
Say, we have web-app A, B, and C. Presently, each has their own login - ie. checks user info in their own db. The idea is not to create a central login. Once we have the user's info, b/c they are already using app. A, if they want to use B, we'll just set column "B" in their user record to "True" - you get the idea. Keep in mind, each app, A, B and C, still have their own db's. So, when user attempts to logon to A, the system will first authenticate on the central user db; everything ok, then continue with using app A's db. My question here is about using multiple db's. Since both connections do not have to be open simultaniously, it should be alright: open user db; check; set good/nogood; close db; open app db.
Setting Up A Home Practice Server MYSQL
I am looking for some tips on setting up a practice server for mysql.. I have a computer set aside to do this. I am thinkning of just putting linux on there. As far as these things go I would need to get a server program such as Apache?? I will also need PHP installed as welll as PHPMyadmin to help with mysql??? I am very new to this server/database because I have always worked with windows 2003 server already in place.
MySQL To Excel -- Setting Column Width In Excel?
Is it possible to set the width of a column in Excel when exporting a table from MySQL to Excel? If so, how is it done and what other type of formatting can be done (ie, bold, background color, etc?)
Setting Up
Im wanting to set mysql/php on my mac. Im wondering if installing mamp is the same as installing each component seprerately. Can i get away with mamp or should i go through and set it up manually?
Setting Up An ISP
I am trying to figure out how to setup an ISP. I have broadband in my shop and was thinking, I could setup the house to call into my network and connect to the Internet through my DSL. I have servers with Mandrake 10.1 for web/mail/ftp. Was wondering if this could be done and what needs to be done for it to work?
Setting Up
I need to setup on which directories on my hosted servers. I am a member of a volunteer organization, but would like to have a wiki posting to help promote some of the events that have lower turnouts. Also to get comments and perhaps media from some of the more successful events. I'm very new to this and am still reading up on some reference materials, but would like to have something tangible to work off of. Our budget is limited as well so I opted for the low budget plan for now, so I am still uncertain of the bandwidth I need.
Setting It Up
I need help on setting mySQL 4.0 on my windows 2000 small business edition server. how exactly do i do it? its downloaded, and set-up, now how do i use it?
Setting Value
I have a table (cont_id) with an auto_increment primary key, and I had deleted entries with much higher numbers than others.Those entries are no longer there, but auto_increment sets cont_id based on the high-number entry I deleted.Is there a way to re-set auto_increment so it adds +1 to the highest-number value for cont_id among the existing entries?
Setting A New Value
I'm trying to design an internet forum these days ... In my database i have got a field called (ID) which represents the id of the topics and i have assigned it an (auto_increment) attribute... My problem is that when i delete all the topics from the forum and after that add a new topic to the database the (ID) of that new topic continues to increment from the last deleted topic, so how can i set the (ID) of the new topic to 1 in case all the previous topics were deleted?
Setting Up Tables
I'm having trouble figuring out the table setup and normalization I'll need to accomplish my goal. Basically on my website I want students to register and from there they can log in and fill out what college they go to and create a list of courses they are taking and add/delete assignments for each course, and add grades they receive for each course. I need help determining what tables I'll need and how I want to link them. Let's say a STUDENT adds 6 COURSES and then 10 assignments in each course along with 8 grades he has received in the past week (to calculate GPA). How would I go about setting this up?
Setting Up Problemo
IM a database virgin and am wanting to get in to server side scripting. Ive been trying to set up mysql on my machine by following this tut: http://www.sitepoint.com/article/php...1-installation Now ive got the mysql downloaded and installed n my machine and ive got to the point where ive opened the command prompt (im on windows xp) to installing mysql as a system device ( right towards the end of the first page in the tut). Now ive got mysql in program files si im typing exactly this: c:programfilesmysqlin>mysql-nt --install but it doesnt work. Says the system cannot find the path specified but to get to the bin folder i literally go c rive then programfiles then the mysql folder then theres the bin folder right there. Any ideas what i could be doing wrong. I dont have apache installed or anythig yet becuase the tut hasnt told me to. Is it all case sensitive, should there be a space between program and files? any ideas?
Setting Font
I downloaded and installed mysql-essential-4.1.22-win32 somedays ago. I found it doesn't support my mother tougue. How can I set it support korean language? should I install it again for setting font(character)? or can I modify the setting?
Setting Up A Database
I have just installed mySQL v.5 on my Windows VPS Remote Desktop. In the past I've use shared hosting and simply followed the directions of the web host when creating a database. I simply need a single database created, a single user created for the database and password. And to grant permissions to that user. Rather than read the manual, I was hoping someone could instruct me on accomplishing this, please.
Setting All Instances Of A Value To Zero?
I am writing a basic CMS for a project and i need to be able to set every instance of a value to zero in a mysql database. eg. there are 20 entries, each with the value '1' in the 'default' column. I want to change all of their 'default' values to 0 in one query. How can i do this?
|
TRACKER
