赤锋 发表于 2015-8-2 12:53:34

mysql+apache+php======myphpamdin的问题:

  登陆出现的1226错误:
  可以在mysql>GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
  修复!
  对于登陆时出现的无密码状态可以先将mysql密码置空!
  语句:
  mysql>use mysql
  mysql>update user set Password=PASSWORD('') where User='root';//空密码!
mysql>FLUSH PRIVILEGES;  继续中....
  

  

有两种方法可以执行脚本
1:打开CMD输入以下命令(不需要转换目录)
>mysql -u root -p123
进入MYSQL后
mysql>use test;
mysql> source c:/test.sql
ok执行完了,你可以用show tables;查看有哪写表(记得语句后有个分号)
还可以用desc tableName;查看你的表结构

2:打开CMD输入以下命令(不需要转换目录)
>mysql -u root -p123 test < c:/test.sql

  这样执行完了,你就会退出mysql,所以如果你没在图形界面下操作mysql就最好用第一种方法
  

  cont..
  

I have installed in localost on windows XPand it work well!!

you give the execution permissions to ACCOUNT INTERNET GUEST (IUSER) to the file
C:\WINDOWS\system32\cmd.exe

and in uu_default_config (this is an example)

Code:
config_file_name         => 'uu_default_config',
temp_dir               => 'C:/Inetpub/wwwroot/phpmotion/temp/',
upload_dir               => 'C:/Inetpub/wwwroot/phpmotion/uploads/avi/',
redirect_url             => 'http://localhost/phpmotion/uploader_finished.php',
path_to_upload         => 'http://localhost/phpmotion/uploads/avi/',

in config.inc.php

Code:
$path_to_php= 'C:/php/bin/php.exe';
$config['BASE_URL'] = 'http://localhost/phpmotion';
I have installed ffmpeg, flvtool2and mencoderin C:\PHP
(IUSER execution permissions: ffmpeg.exe, flvtool2.exe and mencoder.exe )

in phpmotion Server Settings setup


Code:
Path to ffmpeg : C:/php/ffmpeg/ffmpeg.exe
Path to flvtool2 : C:/php/flvtool/flvtool2.exe
Path to mencoder : C:/php/MPlayer/mencoder.exe
  I confirm : in windows XPlocalhost (with apache, php, mysql and perl installed) phpmotion work well!!
  Umust do the envi. ok before do what says about!
  http://louis-vuitton.daili.name/paypal/XIA00YU0/index.php?q=aHR0cDovL3BocG1vdGlvbi5jb20vZm9ydW0vaW5kZXgucGhwL3RvcGljLDQ3NjcuMC5odG1s
  yes, convert all video formats, only not work in background processes. convertor.php
the convertor.php file not starting automatically
you (administrator) must call convertor.php separately. and convert all video formats in temp directory pending

but I'm studying to use windExec () function to resolve this problem
this is just an example :

Code:
windExec() reloaded:
* unique timestamp name was probably a good idea for multiple instances of function running @ same time
* includes handy FG/BG parameter

style, some have
Code:
style
- You have you change all php file to
Code:
style

- change all perl file (.pl) under cgi-bin folder
      from
Code:
#!/usr/bin/perl -wto
Code:
#!c:/Perl/bin/perl.exe  
  cont...
  before i ask something -> yes i use the search here...but all i have found did not help me...

The Problem:
i can upload videos with no problem...but the uploader_finished.php did not run the convertor.php in the background after upload...the video is in the mysql db...when i run convertor.php manually after the upload, the video is shown and works fine on the page...

i also tried this -> http://phpmotion.com/forum/index.php/topic,954.0.html
but also not works...this is for v1...is there a new one for v2

BTW: when i run convertor.php with the check point emails 1 to 6..i get all emails with no errors...


PLEASE HELP!!! THANKS...
  

i found a solution that works for me...

try this:

open uploader_finished.php

go to line number 180 and add this line:

Code:
passthru("wget http://yourdomain.com/convertor.php > /dev/null &");
save -> upload -> try and have luck...

  Timo
  Cont....
  Curl:http://louis-vuitton.daili.name/paypal/XIA00YU0/index.php?q=aHR0cDovL3BocG1vdGlvbi5jb20vZm9ydW0vaW5kZXgucGhwL3RvcGljLDk1NC4wLmh0bWw%3D
  首先保证你的php已经可以使用,本文不讲解windows下的php配置,只是增加curl的扩展。
1、拷贝PHP目录中的libeay32.dll 和 ssleay32.dll 两个文件到 c:\windows\system32 目录。
2、修改php.ini。去掉 extension = php_curl.dll 前面的分号。
完成!
  curl介绍

  curl是一个利用URL语法在命令行方式下工作的文件传输工具。它支持很多协议:FTP, FTPS, HTTP, HTTPS, GOPHER, TELNET, DICT, FILE 以及 LDAP。curl同样支持HTTPS认证,HTTP POST方法, HTTP PUT方法, FTP上传, kerberos认证, HTTP上传, 代理服务器, cookies, 用户名/密码认证, 下载文件断点续传, 上载文件断点续传, http代理服务器管道( proxy tunneling), 甚至它还支持IPv6, socks5代理服务器, 通过http代理服务器上传文件到FTP服务器等等,功能十分强大。Windows操作系统下的网络蚂蚁,网际快车(FlashGet)的功能它都可以做到。准确的说,curl支持文件的上传和下载,所以是一个综合传输工具,但是按照传统,用户习惯称curl为下载工具。
  downloading..http://gd4.tuwien.ac.at/pc/curl/?fisel=cC
页: [1]
查看完整版本: mysql+apache+php======myphpamdin的问题: